I would like to cut the first character in each cell of column B.
-Example the cell may contain 6008, I would like to change that to
008. Also, cell may contain G302; this should be just 302.
Is there a function or macro that i can use to do this?
I have found a useful function: =RIGHT(B2,LEN(B2)-1), however it
requires a circular reference to work.
I also did this: =RIGHT(6004,LEN(6004)-1) which doesn't require a
circular reference, however i need to use this function throughout 10
Can someone help me with this function or module?