formula for moving text to colums

[RAYART]

HI Guys
I am looking for a formula that can do this:
if row contains the word "center" move it column named "school"
if row contains the word "street "move it column named "street"
this is the data I have:
row1: Miami k-8 center
row2: 2301 NW 87 street
row3: Miami, Fl 33166
row 4: kendall k-8 center
row 5: 8200 SW 8 street
row 6: Miami, Fl 33185
etc etc

<tbody>
</tbody>

<tbody>
</tbody>

 

[Deep Dave]

Assuming that above data is in Row A2:A7, Column Header in B1 = Center & C1 = Street.

Put the formula with thew above setting in Cell B2, and drag down and across.

=IF(ISNUMBER(SEARCH(B$1,$A2)),$A2,"")

Deep

 

[RAYART]

WOW!! you saved my day thank you very much

 

[Deep Dave]

Glad it helped..

Deep