formula that can return the text in a field starting from the 4th character

I need a formula that can return the text in a field starting from the 4th character from the left.
*
From the field with ABCD12345 the next column should return 12345 or 123ABCDE
would be BCDE


Note – the initial field has varying lengths.
ABCD1234
ABCD12345
ABCD123456

Hi Ron,

That works. Thank you!

How do I change the forumla so it will automatically look in the correct row number. Example: I want to paste this formula in to 26b-50b and look at the corresponding A cells?

Thanks again.

Originally Posted by Ron Coderre

It seems like this would work for you:
=MID(A1,5,LEN(A1))

Does it?

This also works.

How do I change the forumla so it will automatically look in the correct row number. Example: I want to paste this formula in to 26b-50b and look at the corresponding A cells?

Thanks again.

Originally Posted by MarvinP

Hi Davidwebb and welcome to the forum,

Another answer might be

=RIGHT(A1,LEN(A1)-4)