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