Change First name to abbreviated version

[beaglesBuddy]

Hi,
If i have a column of names, ie. Jack Johnson. How do i abbreviate the first name in that cell so it looks exactly like J. Johnson

Thanks.

[Ace_XL]

Try

=LEFT(A1)&". "&TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",255)),255))

[Jacc]

Try this:

=LEFT(E6,1)&". "&RIGHT(E6,LEN(E6)-SEARCH(" ";E6))

[beaglesBuddy]

thanks for your help