Help with replacing items within a cell

  • Thread starter Thread starter Tchiyuka Cornelius
  • Start date Start date
T

Tchiyuka Cornelius

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.
 
Work with a copy before trying this:
If your data is "equally" spaced - do a select ALL - then convert t
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 th
way you want - then copy and paste
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

return a value in one cell based on multiple formulas 2
Compare two worksheets with "contains" and not "exact" values 1
"Replace" problems 2
Using SUMIF with RIGHT() 5
Help with time function 4
Replacing special characters in Excel 2007 3
using the =page! feature to transpose a row to column 0
How can I find items that have a certain prefix and define? 3

Back
Top