Thread
:
leave only first letter of last name
View Single Post
#
6
Max
Posts: n/a
Trash the earlier convolution, sorry
Just try in B1: =LEFT(TRIM(A1),SEARCH(" ",TRIM(A1))+1)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
Reply With Quote