Merging Cells in Excel 1

[PEASLET]

I always have this problem when people forward data to me. This time I've been given data with the STD code & the phone number in separate columns. I need them in the same column for my (Access) database! I think you can do it in Excel but I've tried all the paste specials etc. and various other things but I can't get it to work. Is there some code or something I can use?
Thanks

 

[JVFriederick]

STD in column A, phone number in column B, in column C type :
=A1&"-"&B1

Then copy the formula to all records. This will place a "-" between the entries.

You may need to convert the values to text. Do you want help with that?

 

[PEASLET]

Pure genius!!!!
Thank you so much ... you wouldn't believe how many hours I've wasted in the past over that particular problem!

 

[JVFriederick]

That was a "floater" in tech terms, but I'll take it !!