Need to remove the first 2 characters in string plus spaces on the left with macro

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

Hi,

you can combine Mid function from character #3 with LTrim function

or using Mid function only if needed string starts always from same position …

Hi MArc and thanks. Could you show how it will look in a macro please.

Thanks in advance

Abjac

HI Is it possible to do this with a macro or shall or do i need to use formula. Macro would be best because its part of much sorting.

Sincerely
Abjac

These functions are in VBA inner help, very beginner level …

Maybe:

Sub abjacvv()
Range("A2") = Right(Range("A2"), Len(Range("A2")) - 2)
Range("A2") = LTrim(Range("A2"))
End Sub

Hi John and thanks for the answer. I works great really just as it have to do. How to put a range on it ?, or to last used cell in column A?
Thanks

Sincerely

Abjac

Maybe:

Sub abjacvv()
Dim i As Long
For i = 2 To Range("A" & Rows.count).End(3).Row
Range("A" & i) = Right(Range("A" & i), Len(Range("A" & i)) - 2)
Range("A" & i) = LTrim(Range("A" & i))
Next i
End Sub

Hi John. It works just brilliant. Thanks allot for you help. Its really great.

Have a nice evening

Sincerely'
Abjac

You're welcome. Glad to help out and thanks for the feedback.