=RIGHT(A1,LEN(A1)-2)
Hi,
How could I remove the first 2 characters to a cell
I was thinking LEFT but not sure
Thanks
That's Awesome, thanks for your time
Hi All,
Just thinking one step further,
If the user sometimes has the first 2 characters and sometimes not is there a way to remove the 2 as per above, but if it is just numbers to ignore the first 2 removed
ie
Entered as AA12345, but next day entered as 12345
I would ideally like the AA removed but 12345 left as it is
Thanks