Left, Mid, Right

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Omit the first word from a cell contain text 7
MID function from right to left 3
Lookup against concatenated source value 2
Nested MID and FIND - OR? 3
MID, LEFT, RIGHT help 5
Omitting right part of text string 6
Problem with MID (any text) Command 2
no functions resolve when format of cells is text 7

Top