Forum Discussion
How to concatenate 2 columns without spaces in Exel
What formula is suitable for concatenating 2 columns without spaces here is a screen of what it looks like before and after (the required type of columns). Help me, please.
1 Reply
The formula cannot be in column A of the same worksheet, it would cause a circular reference error.
To concatenate columns A and B as text, enter the following formula in C1: =A1&B1
To concatenate them as a hyperlink, enter the following formula in C1: =HYPERLINK(A1&B1)
Fill or copy down from C1.
