Microsoft Excel tutorial: Combine/ Concatenate/ cells, Reverse Concatenate / split cell, find repeats/duplicates

Combine data/ Concatenate (merge) cells in Excel spreadsheets:

1.       Combine two cells A and B (First name and Last name)

2.       Paste =CONCATENATE(A3, " ", B3) in C3

3.       Click enter and drag to C13

Reverse Concatenate or split cell text into separate columns

1.       Choose the right column or cells. Here Full name column A3 to A11

2.       Click on Data tab in the File, Home row

3.       Click on Text to Columns

4.       Click on Convert Text to Columns Wizard

5.       Click on Delimited (or Fixed Width as per requirement)

6.       Click on Next.

7.       Choose the appropriate Delimiters (Comma, Tab, Space, semicolon). Here Space.

8.       Click Next.

9.       Choose Column data format.

10.   Choose Destination column. In this column the first part is going to appear and in the next column the second part of the text is going to appear. Here B3.

11.   Click Finish. Column gets split into First name and last name

Finding repeats/duplicates in Excel file (string type)

1.       To find duplicates in Column B

2.       Paste formula in a cell like E3 =COUNTIF(B3:B13, B3)>1

3.       Click Enter and drag till E13

4.       TRUE and FALSE gets printed for no repeated text and repeated texts respectively.

or

1.       To find duplicates in Column B

2.       Paste formula in a cell like E3 =IF(COUNTIF(B3:B13, B3)>1, "Duplicate", "")

3.       Click Enter and drag till E13

4.       Duplicates gets printed for repeated texts only.