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

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

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

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.
--
John C


"WalMatt23" wrote:

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

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

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


"WalMatt23" wrote:

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

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

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


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


"WalMatt23" wrote:

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

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

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
--
tech1NJ


"Rick Rothstein (MVP - VB)" wrote:

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


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


"WalMatt23" wrote:

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

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

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

Rick


"tech1NJ" wrote in message
...
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
--
tech1NJ


"Rick Rothstein (MVP - VB)" wrote:

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


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


"WalMatt23" wrote:

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

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

Will do thanks for the heads up.
--
tech1NJ


"Rick Rothstein (MVP - VB)" wrote:

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

Rick


"tech1NJ" wrote in message
...
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
--
tech1NJ


"Rick Rothstein (MVP - VB)" wrote:

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


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


"WalMatt23" wrote:

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

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

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

--
tech1NJ


"WalMatt23" wrote:

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