Removal of preceeding set of numbers

[robbie1507]

Hi all,

Hope all is well.

I have a large spreadsheet that I am working on but require a certain amount of numbers to be removed so that it leaves a more meaningful number behind. I'll explain better below:

I have a number of my spreadsheet as follows:
010237001010848
I need to remove the number "01023" as this number is a company number and I have a lot of entries that have this, yet we really only use "70001010848".

Can someone advise how i can get rid of the preceeding 5 numbers?

Thanks
Rob

[Lotus123]

Option 1: Edit->search and replace. Replace all occurances of 01023 with (blank...don't put anything in the replace field"

Option 2: Presuming the numbers are in column A: =RIGHT(A1,LEN(A1)-5). I took a length of the cell in case the numbers are all of varying length.

Option 3: Select the column with these numbers and choose data->text to columns. Just split the first 5 characters from the rest of the group.

Hopefully one of the above works for your situation!