Please Help with a TEXT formula

[srhino]

I really need some help with a formula I am importing from the web and when the information comes in it comes in a text string like below...

Jim Owens (10)

I would like to use a formula to change the incoming names to just show the first letter of the first name and then a period and the full last name. it would output like the following

J.Owens

**I can't text to columns the information because it refreshes every 60 seconds**

Thanks In Advance

 

[VoG]

Try

=LEFT(A1)&". "&MID(A1,FIND(" ",A1)+1,FIND(" ",SUBSTITUTE(A1," ","~",1))-FIND(" ",A1))

 

[JamesW]

Hi,

Do the Names always have (10) at the end? Do you want to keep the (10) if they do?

If they don't then:

=LEFT(A1,1)&"."&MID(A1,FIND(" ",A1,1)+1,LEN(A1)-FIND(" ",A1,1))

 

[srhino]

Awesome....Thanks James and Peter
that was a huge help! I really appreciate it!