Hi I need help to remove the first 2 characters in string in column A.
I need a macro for it because its part of bigger sort.
The 2 first characters and also if it can remove spaces in the left in the text it will be great.
Below is a text string. To put in cell A2. Please have a look I need a macro for it.
Here is an example of the string with spaces also
Please have a look
Sincerely
Abjac
.. 280714 B2A2498900 GBP 37,728.00 PAY 00666676
Wanted result will be
280714 B2A2498900 GBP 37,728.00 PAY 00666676
Bookmarks