With a formula:
=A1 & ", " & B1 & ", " & C1

or in code

sStr = Range("A1").Value & ", " & Range("B1").Value & ", " &
Range("C1").Value

Range("B9").Value = sStr

--
Regards,
Tom Ogilvy

"abxy " wrote in message
...
I'm in the middle of creating a UserForm, but this question is less
about the UserForm and more about just simple programming I suppose...
Ok, I have 3 cells, one with the City, one with the State, and one with
the Zip code.

..I want to have another cell to display display the values of all 3
of those cells in a "City, State, Zip" format. How do I do this?


---
Message posted from http://www.ExcelForum.com/