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

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
[email protected]
 
J

John C

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.
 
T

tech1NJ

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.
 
R

Rick Rothstein \(MVP - VB\)

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
 
T

tech1NJ

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
 
R

Rick Rothstein \(MVP - VB\)

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

Rick
 
T

tech1NJ

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...
 
T

tech1NJ

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
 
Top