Hi,

I am wondering id there is any function in VBA which can replace designated leading letters in a text with nothing.

For example, let say in a cell I have "AAAAA235263", and I want to remove leading "AAAAA" and want to get only "235263".

Any pointer will be very helpful.