Hi all
Just a quick one i hope. Any way to solve this without a macro? I got a row with 10 to 13 digit numbers (some will have a letter in the end i want to keep) some will have two letters in front and i would like to remove the first two letters if they are presents and if not, just to display the number. ps there will always be a space between the first two letters and the number
Example:
074564368X
0745622070
WB 1118297709
BP 9865434567654
9865474567850
Wanted result:
074564368X
0745622070
1118297709
9865434567654
9865474567850
Thanks in advance for the help
Bookmarks