Deleting unwanted spaces

[borchesz121]

I have a list of city and states that have spaces between them. For example right now I have:

Atlanta, GA.

What I want to get is:

Atlanta,GA.

I want to have some type of formula that will delete the space between the comma and the state. I've got a couple thousand city state combinations that I can't go through and delete each space.

Any ideas?

[Domenic]

Assuming that Column A contains your list...

B1, copied down:

=SUBSTITUTE(A1," ","")

Then, select the new column, and...

1) Edit > Copy

2) Edit > Paste Special > Values > Ok

Hope this helps!

[borchesz121]

Thanks! for the help