Editing a list of names that have numbers- Can i take out the numb

  • Thread starter Thread starter WalMatt23
  • Start date Start date
W

WalMatt23

I have a bunch of data in a spreadsheet that has lists of names such as

1. Smith
2. Hanson
3. Rodriguez

is there a command or series of commands to edit this column of data to
remove the number, the period, and the space before the beginning of each
name?

Thanks in Advance
Matt
(e-mail address removed)
 
Assuming you have a long list of data such as this, and this data starts in
A2, in B2, type the following formula:
B2: =SUBSTITUTE(A2,LEFT(A2,FIND(" ",A2)),"")
Copy down as needed.
If you want this change to be a 'permanent' change, highlight your data from
B2 to B? (whatever), copy, then paste special value on top of itself. Delete
column A.

HTH.
 
This should not be too hard. Assuming that all your data is in one column.
1: Select /highlight the range/column with the numbers and names.
2: Go to the Data menu, select TEXT TO COLUMNS.
3: Select the DELIMITED option, press NEXT
4: Select the SPACE option, press NEXT.
5: Press FINISH
6: Delete the unwanted column with the numbers.
 
This should not be too hard. Assuming that all your data is in one column.

One more assumption... none of the text after the number/period/space have
spaces in them; that is, you do NOT have an entries like these...

4. John Smith
5. Hanson, Roger Joseph

Rick
 
The fix depends on the character variation that you have. Will be possible
for you to place a good sample of the data you have indicating the different
data you are dealing with? This will help us help you.

Thanks
 
You probably should have posted your message against the OP's original
posting rather than mine... he may not see it here.

Rick
 
Will do thanks for the heads up.
--
tech1NJ


Rick Rothstein (MVP - VB) said:
You probably should have posted your message against the OP's original
posting rather than mine... he may not see it here.

Rick
Click to expand...
 
The fix depends on the character variations that you have. Will it be
possible for you to place a good sample of the data you have indicating the
different data you are dealing with? This will help us help you.

Thanks
 
Back
Top