Results 1 to 7 of 7
  1. #1
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Remove character from the entire row (Excel 2

    Hi There

    I will assume that the string length will not be the same:

    =right(A1, len(A1)-1)


    hope that helps
    Jerry

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Remove character from the entire row (Excel 2003)

    You first say row and then say column. Do you want to remove the first character from a row or a column?

    If you want to remove the first character of row 1, then you could do the following:

    1- Insert an empty row below row 1.

    2- In cell A2, enter the following formula:

    <code>
    =IF(A1<>"",RIGHT(A1,LEN(A1)-1),"")
    </code>

    3- You should now have in A2 the string in A1 without the first character. Copy the fomula in A2 to the right as far as need to get all of the strings in row 1.

    4- Select all of row 2 by clicking the "2" row label at the left, and then select Copy from the Edit menu.

    5- Select "Paste Special" from the Edit menu. In the resulting dialog box, put a tick mark next to Values in the paste section and click on OK.

    6- You can now select and delete row 1.
    Legare Coleman

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Remove character from the entire row (Excel 2003)

    Welcome to Woody's Lounge!

    In addition to Jezza's reply: if your IDs are in column A, starting in A1, Jezza's formula should be inserted in B1, and filled down as far as needed. If your IDs are in another column or start lower down, change A1 in the formula accordingly. You could also use
    <code>
    =MID(A1,2,100)
    </code>
    where 100 is an arbitrary number larger than the length of the longest ID.
    After creating the formulas, you can hide the column with the original IDs, if you wish. Or you can copy/paste special the new column as values, then delete the original column.

  4. #4
    New Lounger
    Join Date
    Jun 2007
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Remove character from the entire column

    Hello, Professionals!

    I have a column with some IDs and I need to remove first character form the entire column. Could you please advise which function can be used to delete first character in whole column? Thanks for any help!!!

    For ex: A1223456789
    B2345678900

    Needed result : 1223456789
    2345678900

  5. #5
    New Lounger
    Join Date
    Jun 2007
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Remove character from the entire column

    Sorry for the confusion. Topic should be Remove character from the entire column, I corrected the mistake. Thanks everybody for your help!!!

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Remove character from the entire column

    To remove the first character of column A, change my instructions to:

    1- Insert an empty column to the right of column A.

    2- In cell B1, enter the following formula:


    =IF(A1<>"",RIGHT(A1,LEN(A1)-1),"")


    3- You should now have in B1 the string in A1 without the first character. Copy the fomula in B1 down as far as need to get all of the strings in column A.

    4- Select all of Column B by clicking the "B" column label at the top, and then select Copy from the Edit menu.

    5- Select "Paste Special" from the Edit menu. In the resulting dialog box, put a tick mark next to Values in the paste section and click on OK.

    6- You can now select and delete column A.
    Legare Coleman

  7. #7
    New Lounger
    Join Date
    Jun 2007
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Remove character from the entire column

    Thank you very much!!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •