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
|