Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: phranque
If you have something in A1 and B1 and want to combine to C1, put this in C1 (this takes the text from A1 and B1 and adds a space between the two.
Then just copy the formula in the rest of the C column by pulling the corner of C1 down.
If you want the merge to be a permanent value, just copy the results of the C column and Paste Special into a blank column using "values". That's it.
If you need a space try: