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

Posted to microsoft.public.excel.worksheet.functions

WalMatt23

external usenet poster

Posts: 2

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Making a list of discrete numbers (names?) and occurences of each	partsman_ba	New Users to Excel	10	August 22nd 09 03:02 PM
Matching numbers in an Array and returning values for matched numb	Tiger	Excel Discussion (Misc queries)	8	April 26th 07 06:14 AM
How do I sum up only the numbers in cells containing text and numb	LfmC	Excel Discussion (Misc queries)	3	October 6th 06 10:24 PM
How can I change a list of phone numbers into peoples names	John	New Users to Excel	2	August 29th 06 12:46 PM
How 2 separate column of addresses into a colum of names and numb	Rochelle	Excel Discussion (Misc queries)	3	April 26th 05 10:02 AM

All times are GMT +1. The time now is 08:56 PM.

Menu

About Us