Extracting text
Hi Rohit,
Try this formula... First do a "Find & Replace". Find " "
(spacebar) and replace with "" (nothing).
=LEFT(A1,LEN(A1)-7)
Hope this helps...
Chong Moua
-----Original Message-----
Hello All,
I have the following values listed in a column on a sheet.
Campatelli, Pamela 0158299
Sin, Pho 0164184
Sheldon, Sheila 0364181
Schofield, Joan 0523983
Souza, Patricia 0328789
Coakley, Julie 0354129
From these values, I need to remove all numbers and
spaces
after the name. I've tried several TEXT functions with no
luck. Any suggestions on how I can extract the name??
Thanks,
Rohit Thomas
.
|