ExcelBanter - Text Extract

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Text Extract (https://www.excelbanter.com/excel-worksheet-functions/59990-text-extract.html)

Arturo

Text Extract

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 Im 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

Gary''s Student

Text Extract

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

--
Gary's Student

"Arturo" wrote:

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 Im 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

All times are GMT +1. The time now is 10:36 PM.