Try this, Phil:

http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"Phil" wrote in message
...
Hello,

I have a cell that has 3 values in it, and want to BREAK it up so that
instead, I will get 2 MORE NEW rows, for a total now of 3 rows. I believe
the values were inserted into the cell using the CTRL+ENTER key
combination.
There is a non-printable character (ANSI 0010) visible in the EDIT window
to
make the new line.

Also, there are instances where it may be only 2 values (which occurs MOST
of the time), or other instances where there may be as much as 5 values in
the same cell.

Here is a typical cell: (obviously you can disregard the COL and ROW
references)

COL- A COL - B COL - C
ROW-1 Tract_No Parcel_ID Owner
ROW-2 8-5-012-045 251254 Floyd Daniels
ROW-3 7-5-065-012
ROW-4 8-6-045-012

So what I want to do is to create a 2 MORE new rows to read like this:

COL- A COL - B COL - C
ROW-1 Tract_No Parcel_ID Owner
ROW-2 8-5-012-045 251254 Floyd Daniels
ROW-3 7-5-065-012 251254 Floyd Daniels
ROW-4 8-6-045-012 251254 Floyd Daniels

How can this be done?

TIA for your replies.

Phil.