Pasting contents of cells into other cells, HELP!

[Randy801]

OK,

I have a massive Excel 2003 spreadsheet with two particular columns whose address info I wish to merge.

Example:

A1
John Smith, 123 Smith Street

B1
New York


I wish to have B1's contents pasted on the end of A1's to make:


A1
John Smith, 123 Smith Street, New York


I am pulling my hair out with Macros and VBA trying to figure this out. I have thousands of rows of this I wish to have merged. Both cell contents are formatted as "general", not text. And I do desire the comma between the street and the pasted city.

Any help would be appreciated. I've spent hours on this and I'm determined to not do this manually.


Randy B