Extracting data from Excel cells

[woolfie17]

I posted a problem a couple of days ago and got two EXCELLENT solutions. We are trying to extract data from several thousand records. We have the data as follows; in column A is the name of the school or camp, and in column B is their city, state, and phone number. Here is an example of two column B entries:
Montclair, NJ 201-655-4104
Bear Mountain, NY 201-672-9500
I am trying to separate city, state and phone number into individual columns. I was able to use =RIGHT(B1,12) to get the phone number into column C. Is there a way to copy the data into a new column and eliminate the data in the right 22 positions to leave just the city name, regarless of size?
Thanks for your help.

[Davadvice]

Hello,

You can use the text to columns function for this.

Select the data in column B then click the "data" button on the menu, you may have to expand the menu. now click Text to columns. click next, select the comma tick box, and click finish,

repeat the above step selecting the column you have the new data in. now select the Space tick box and unselect the coma check box.

you will then need to move the data back to the column you wish to keep the data.

thanks

David