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

.