The easiest way is to add a column with a formula that throws away the 5 leftmost characters of the original cell. Then use Copy>Paste Special to replace the original column.
I'll leave it to you to assemble the all-in-one formula, but these are the elements:
- length of contents: =len(a1)
- subtract 5
- use right-function to extract the needed characters
Ok I have a spreadsheat that goes down 999 cells down vertically and there is one row that contains text in the following format "0524 Blabla" what im trying to do is remove the number and the space for all 999 cells so it looks like "Blabla"
Thank You for any help.