I have to split the text below into separate fields. I can't use the
Text to Columns command b/c as you can see, the text changes from Cell
to Cell. Most of the text is carriage return delimited but b/c it's
not all the same type of data, I can't deal with it on a global basis.
I need to write an IF Function I think based on a condition that I
specify, but I don't know the syntax for this...help!!

Cell 1
Sari
Allegro Palm
Belmont
Preserve at Temple Terrace

Cell 2
Developer's Sales Team
Realtor-Broker


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