Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Isolate text following a period (".")
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 |
#2
|
|||
|
|||
Hi Tom
you can use =MID(A1,SEARCH(".",A1)+1,3) Regards JulieD "tommcbrny" wrote in message ... 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 |
#3
|
|||
|
|||
One way:
=MID(A1,FIND(".",A1)+1,3) If A1 might not contain a ".": =IF(COUNTIF(A1,"*.*"),MID(A1,FIND(".",A1)+1,3),"") In article , tommcbrny wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
How do I rotate a text box | Charts and Charting in Excel | |||
how to hyperlink text to a cell | New Users to Excel | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
Text Boxes | Excel Discussion (Misc queries) |