How to use Excel find or search

Left-click the cell, then click Data -> Text To Columns.
Select Delimited, then click Next.
Click the Comma checkbox, click Next.
Click Finish.

Ok, you should now have
7550 Wilshire Place Drive in CellA
Houston in CellB
TX 77040 in CellC

So, almost there!
Now, click CellC, which has TX 77040 in it, and then click Data -> Text To Columns.

Go through the same Delimited procedure as before, only select the Space checkbox to separate using a Space character as a delimiter. Finish it, and there you go. The Zip code will be in CellD, with the state in CellC all by itself.

You now have the address in A, City in B, STate in C, and Zip in D.

You can do with with columns of data also.

hope this helps

1) Select the cell u need to separate the comma.
2) Click "Data" and go to "text to colums"
3) Default is "Delimited" and click "next"
4) Just tick the "Comma" and click "Finish".

Hope this helps.