How to concatenate 2 columns without spaces in Exel

[Polina_microsoft]

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.

[#2]

@Polina_microsoft 

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.