Sure - I pasted the first 123 rows. There are many more rows, but this
should give you an idea of what the structure is. There are really two
types of data that I need to extract from this column and place into new
columns. Project Type and Agent. Prospect can stay where it is in this
column, which is ContactType. The project and Agent shouldn't even be
here.
![Smile :) :)](/styles/default/custom/smilies/smile.gif)
Thanks.
Allegro Palm
" Sari
Allegro Palm"
"Prospect
Radius"
Prospect
"Sari
Panama - Pacific Point"
Prospect
Prospect
Prospect
Prospect
"Prospect
Trump Towers 1"
Prospect
Prospect
Prospect
Prospect
Prospect
"
Belmont"
Prospect
Allegro Palm
Prospect
"Jordana
Prospect"
"Prospect
NuRiver Landing"
Prospect
Prospect
Prospect
Belmont
Prospect
Prospect
Prospect
" Manfred
Terrazas Grove"
"Sari
Preserve at Temple Terrace"
Prospect
Sari
Manfred
Prospect
Prospect
Prospect
"Prospect (Panama)
Developer"
"
Belmont
Referral"
Prospect
Prospect
"Belmont
Pending sale
Preserve at Temple Terrace"
" Sari
Allegro Palm"
"Prospect
Ocean Marine"
Prospect
" Sari
Allegro Palm"
" Sari
Preserve at Temple Terrace"
Prospect
Prospect
Realtor
Prospect
" Sari
Allegro Palm"
Prospect
Prospect
"Prospect
Ocean Marine"
Prospect
Prospect
Prospect
"Prospect
Nobe Bay"
Allegro Palm
"Prospect
NuRiver Landing"
Realtor (MY TEAM)
Prospect
Prospect
" Jordana
Prospect
Belmont"
Prospect
Prospect
Prospect
Prospect
" Jordana
Preserve at Temple Terrace"
Prospect
Prospect
" Sari
Allegro Palm"
Prospect
"Prospect
Everglades on the Bay"
Prospect
Prospect
" Sari
Allegro Palm
Preserve at Temple Terrace"
"Allegro Palm
Preserve at Temple Terrace
Realtor's client"
Prospect
Prospect
" Sari
Allegro Palm"
Prospect
Prospect
" Sari
Allegro Palm
Preserve at Temple Terrace"
" Irit
Parc Central -East Tower"
" Sari
Nautica
Rivage
Solis"
" Sari
Allegro Palm"
Manfred
"Developer's Sales Team
Realtor-Broker"
" Sari
Allegro Palm
Belmont
Preserve at Temple Terrace"
" Sari
Allegro Palm"
" Richard
Prospect
Trump Towers 1"
Prospect
Prospect
Prospect
" Manfred
Prospect"
" Sari
Preserve at Temple Terrace"
" Sari
Prospect
Allegro Palm"
Prospect
Prospect
Prospect
Prospect
" Jordana
Realtor Broker"
Prospect
Prospect
Prospect
Sari
Prospect
Prospect
"
DaVinci on the Ocean"
Prospect
"
Preserve at Temple Terrace"
Sari
Prospect
Preserve at Temple Terrace
Prospect
Manfred
"Prospect
Listing prospect investor
Realtor-Broker"
" Jordana
Realtor Broker"
Prospect
Prospect
" Sari
Condos at Lake Worth"
Panama
"Prospect
Terrazas RiverPark"
Prospect
Prospect
"
Beach Club
Seller"
"Prospect
Terrazas RiverPark"
Prospect