Left, Mid, Right
 

Cell A1= A. John Smith

I am not sure how to configure the text functions to omit "A. " without
tagging on an excess of characters to grab after "A. ".

=MID(A1,4,20) works but I am curious if there is way to just omit the first
three characters and return whatever remains in the string.

Appreciatively,
Arturo

Hi

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

Cheers
julieD

"Arturo" wrote in message
...
Cell A1= A. John Smith

I am not sure how to configure the text functions to omit "A. " without
tagging on an excess of characters to grab after "A. ".

=MID(A1,4,20) works but I am curious if there is way to just omit the
first
three characters and return whatever remains in the string.

Appreciatively,
Arturo