Formula to get data from 2 columns into 1

[robertsgw]

I'm trying to write a formula that will take data from 2 columns into 1. The problem is there are spaces. Example below is what i'm trying to do.


Column A Column B Column C
1234 1234
5678 5678
8789 8789
1236 1236

 

[BY70]

Hi Robert,

Can you be more specific to where the spaces are please - maybe show the data in quotes with the spaces shown?

Thanks

 

[niceguy_jay]

if you want the value in C1 then paste this formula in C1

=$A1&" "&$B1

copy paste the above formula till the end of C column

 

[robertsgw]

Thanks Everyone.