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