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.