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
|