Remove part of string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Criteria Values with For Loop 3
HELP: extract certain characters from text string 3
Macro to complete Google search based on a cell? 0
Trying to evaluate cell referenes in a string 3
Help With MS Excel 2007 1
Excel Linking Multiple cells to One cell for Results 0
Concatenating Cells 2
How-To Remove Extra Spaces 4

Back
Top