View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WalMatt23 WalMatt23 is offline
external usenet poster
 
Posts: 2
Default 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