How to concatenate 2 columns without spaces in Exel

%3CLINGO-SUB%20id%3D%22lingo-sub-2264403%22%20slang%3D%22en-US%22%3EHow%20to%20concatenate%202%20columns%20without%20spaces%20in%20Exel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2264403%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EWhat%20formula%20is%20suitable%20for%3C%2FSPAN%3E%3CSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Econcatenating%202%20columns%20without%20spaces%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Bhere%20is%20a%20screen%20of%20what%20it%20looks%20like%20before%20and%20after%20(the%20required%20type%20of%20columns).%20Help%20me%2C%20please.%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2264403%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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

@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.