How to Add Two Column Data in One Column in Excel || Concatenate & Text To Column || Bangla Tutorial
Upload on 20 December 2019
By: Md. Abdur Rahim Farhad
Topic: How to use Concatenate and Text To Column in Excel
Concatenate: Here are the detailed steps: -
1. Select a cell where you want to enter the formula.
2. Type =CONCATENATE( in that cell or in the formula bar.
3. Press and hold Ctrl and click on each cell you want to concatenate.
4. Release the Ctrl button, type the closing parenthesis in the formula bar and press Enter.
Text To Column: How to Use Text-to-Columns in Excel -
1. Open Excel and start a new Blank workbook.
2. Add entries to the first column and select them all.
3. Choose the Data tab atop the ribbon.
4. Select Text to Columns.
5. Ensure Delimited is selected and click Next.
6. Clear each box in the Delimiters section and instead choose Comma and Space.
Thank You
Stay with me.