How to Combine Columns in Excel

Published: 18 October 2020
on channel: WhatVwant - A Technology Vlog

In this method, we don't use the merge and center method to combine columns because it leads to data loss. Instead, we take a formula approach in the tutorial. For more details, click here: https://whatvwant.com/combine-columns...

00:26 Method 1: Combine columns without space
00:36 Step 1: Find row number
00:40 Step 2: Click on a cell where you want to paste the combination of cells.
00:50 Step 3: Type this formula
00:56 Step 4: Hit enter
01:04 Step 5: Apply the formula to all remaining columns.
01:13 Method 2: Combine Columns in excel with space or any special character

Watch video How to Combine Columns in Excel online, duration hours minute second in high quality that is uploaded to the channel WhatVwant - A Technology Vlog 18 October 2020. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 92 times and liked it 1 visitors.

2,794,773

18K