Macro to remove the first two characters

I have written code to extract the first two characters in Col A which happens to be 2 asterisks

I have attached sample data

I get type mismatch & the following code below is highlighted

Please Login or Register  to view this content.

See full code below

Please Login or Register  to view this content.

It would be appreciated if someone could assist me

Hi,

to remove the first characters just use the VBA Mid statement …

Please Login or Register  to view this content.

thanks for the advice Marc

Thanks for the help, Jindon