Isolate text following a period (".")

T

tommcbrny

Hello...I am trying to create a function that will populate a cell with the
first three text characters that follow a period (".") from a text string in
another cell. Can anyone tell me whether there is a function that will allow
me to do this?

Thanks,
Tom
 
J

JE McGimpsey

One way:

=MID(A1,FIND(".",A1)+1,3)

If A1 might not contain a ".":

=IF(COUNTIF(A1,"*.*"),MID(A1,FIND(".",A1)+1,3),"")
 

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

Macro to Select text from a point given to a specific word 2
Word isn't capitalizing the first word of each sentence 2
Link a text box based on drop down box with four options MS Word 365 0
Visio shape text disappears upon copy paste 1
search cell for specific text. 1
Formating bolded text exclusively. 0
Disable Outlook AutoCorrect with GPO 0
Page numbering with Merged Document and IF statements 1

Top