Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel query

Options
  • 27-07-2017 3:20pm
    #1
    callaway92
    Registered Users Posts: 14,704 ✭✭✭✭


    Hi all,

    I'm trying to do the below in excel. Basically I have a column with a code that has a letter as the start of it (thousands of cells in the column).

    I want to remove the first letter from each cell.

    However, when I insert a new column alongside it and do a formula to remove the first letter and then delete the incorrect column, the formula fails.

    Example below. If anyone could help it would be great. Basically, I need column A to get the S off every cell

    Thanks v much

    A2emEi.jpg


Comments

  • Options
    #2
    grogi
    Registered Users Posts: 8,615 ✭✭✭grogi


    Write formula, copy the results and do 'Paste Special -> Values'.


  • Options
    #3
    Victor
    Registered Users Posts: 78,417 ✭✭✭✭Victor


    Will a find and replace do it?


  • Options
    #4
    callaway92
    Registered Users Posts: 14,704 ✭✭✭✭callaway92


    grogi wrote: »
    Write formula, copy the results and do 'Paste Special -> Values'.

    You the man.

    Thanks buddy


Advertisement