Text Extract

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arturo - 12 Dec 2005 16:11 GMT

Cell W3= Smith, Joseph
=LEFT(W3,FIND(" ",W3)-1) gives me the left text including “,”.
=RIGHT(W3,LEN(W3)-FIND(" ",W3,1)) gives me the last word in the string.
The end result I’m trying to get is “Smith, J”
Looking for a way to pull the first letter after the comma and concatenate
that into the left formula…
Direction appreciated.
Arturo

Reply to this Message

Gary''s Student - 12 Dec 2005 16:24 GMT

=LEFT(W3,FIND(" ",W3)+1)

Signature

Gary's Student

> Cell W3= Smith, Joseph
> =LEFT(W3,FIND(" ",W3)-1) gives me the left text including “,”.
[quoted text clipped - 4 lines]
> Direction appreciated.
> Arturo

Reply to this Message