Combining multiple columns into one in Excel

This is the easiest way to take the contents of multiple columns and combine them into a single column.

My example uses the ip address 192.168.0.1 where each octet and each . between each octet exists in a different column.

Choose a cell, and enter the following formula…  It’s just like doing a SUM to add numbers, only you use CONCATENATE instead.

Hit enter and voila.

Did you like this?
Tip cyberfella with Cryptocurrency

• Bitcoin
• Monero

Donate Bitcoin to cyberfella

Scan the QR code or copy the address below into your wallet to send some bitcoin:

Donate via Installed Wallet Copy

[X] Click Here to Hide Donation Details

Donate Bitcoin Cash to cyberfella

Scan the QR code or copy the address below into your wallet to send bitcoin:

Donate via Installed Wallet Copy

[X] Click Here to Hide Donation Details

Donate Ethereum to cyberfella

Scan the QR code or copy the address below into your wallet to send some Ether:

Donate via Installed Wallet Copy

[X] Click Here to Hide Donation Details

Donate Litecoin to cyberfella

Scan the QR code or copy the address below into your wallet to send some Litecoin:

Donate via Installed Wallet Copy

[X] Click Here to Hide Donation Details

Donate Monero to cyberfella

Scan the QR code or copy the address below into your wallet to send some Monero:

Donate via Installed Wallet Copy

[X] Click Here to Hide Donation Details

Donate ZCash to cyberfella

Scan the QR code or copy the address below into your wallet to send some ZCash:

Copy ZCash Address

[X] Click Here to Hide Donation Details