String Manipulation

  • Thread starter Thread starter Mviper
  • Start date Start date
M

Mviper

I have a listing of names in a single cell. (ie Smith,Tom). The list i
over 2,000 name long. I wish to be able to take everyting from left o
the comma ( ie Cell A1 Smith A2 Tom). I hope i am clear in what
want to do pls help
 
Hi Mviper!

Use:

=LEFT(A1,FIND(",",A1)-1)

Or you could use Data > Text to columns using , as the delimiter. That
has the advantage of giving you both names in separate columns.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi
try the following
- select your column A
- goto the mnue 'Data - Text to columns'
- choose the comma as delimiter
- finish the wizard

Another way: If your list is in column A enter the following in B1:
=LEFT(A1,FIND(",",A1)-1)
in C1 enter
=MID(A1,FIND(",",A1)+1,255)
copy both formulas down for all rows
After tthis select column B+C and copy them (CTRL+C). Noe goto 'Edit -
Paste Special' and paste the copied range as 'Value'
 
Thks for the help. What a great site for info. I have bookmark it & will
refer back to it again & again
 
Back
Top