Help with replacing items within a cell
 

I know nothing about using formulas in excel. I'm using "find replace" from
the edit menu to clean up some data. How do I enter multiple item in the
find field? What's the syntax?

More info: I have a data field where there are five digits prefixed by four
digits and suffixed by a name i.e. 01 02 09876 Hammock. I need to isolate
the 5 middle digits in one column, the prefix in a second column and the
suffix in a third column.

So far I have copied the data to three seperate columns and I'm using find
replace to isolate the data in each column but it is tedious. Please help!!
Thanks.

Help with replacing items within a cell
 

Work with a copy before trying this:
If your data is "equally" spaced - do a select ALL - then convert to
Courier Font - then select the column and then go to the MENU Bar -
DATA - TEXT TO COLUMNS and follow the directions.
You can also use the "MID" FUNCTION - setup the first three cells the
way you want - then copy and paste.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=512879