I have a list of names in the format last, first. The whole name is stored
in a variable to be sorted later. How can I remove the , first from the
string before putting it in a cell? Ex. The name is Smith, John. I want to
put this in cell A1 but all I want in A1 is Smith.

Select Column of data - hit Data / Text To Columns / Delimited / Comma as
delimiter - During wizard highlight the seocnd column and choose 'Do Not
Import'. Hit next and finish.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Erik" wrote in message
...
I have a list of names in the format last, first. The whole name is stored
in a variable to be sorted later. How can I remove the , first from the
string before putting it in a cell? Ex. The name is Smith, John. I want to
put this in cell A1 but all I want in A1 is Smith.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.771 / Virus Database: 518 - Release Date: 28/09/2004

--

HTH

RP

"Erik" wrote in message
...
I have a list of names in the format last, first. The whole name is
stored
in a variable to be sorted later. How can I remove the , first from the
string before putting it in a cell? Ex. The name is Smith, John. I want
to
put this in cell A1 but all I want in A1 is Smith.

I think you removed the *whole* string there Bob <g

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Bob Phillips" wrote in message
...


--

HTH

RP

"Erik" wrote in message
...
I have a list of names in the format last, first. The whole name is
stored
in a variable to be sorted later. How can I remove the , first from the
string before putting it in a cell? Ex. The name is Smith, John. I want
to
put this in cell A1 but all I want in A1 is Smith.




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.771 / Virus Database: 518 - Release Date: 28/09/2004