That almost worked, except that some cells are getting separated when I
don't want them to. I think what would be better would be to use some
conditional logic to extract the text that I want from the cells into a
new cell. Which goes back to my initial question. For example, here is
a copy of two of the cells:

" Sari
Allegro Palm"

or

" Sari
Panama - Pacific Point"

or

" Sari
Preserve at Temple Terrace"

so i need to construct an IF statement that says something like if
Preserve at Terrace, insert Preserve at Terrace into a new field. :)


--
gemispence
------------------------------------------------------------------------
gemispence's Profile: http://www.excelforum.com/member.php...o&userid=37113
View this thread: http://www.excelforum.com/showthread...hreadid=568449