Combining Cells - urgent

[borchesz121]

I am in a bind, and need to figure out how to combine cells in a large data set.

What I have is:

Row 1, Column A
Origin City

Row 1, Column B
Origin ST

Row 1, Column C
Destination City

Row 1, Column D
Destination ST

Basically what I am looking to end up with is

Row 1, Column A
Origin City,Origin ST

Row1 Column B
Destination City,Destitnation ST

(no spaces between the comma and states)

Any ideas?
Thanks.

Scott

[daveydave60]

Can you just make two extra columns, say columns e and f, then enter formulas

E2 ----------> = A2 & "," & B2
F2 ----------> = C2 & "," & D2

these will concatenate the entries in the other columns how you want

[borchesz121]

Thanks a lot!