If names are in Column A and Column B, put this in C2

christopher ritzau 20 Reputation points
2026-10-02T17:10:39.33+00:00

If names are in Column A and Column B, put this in C2

Microsoft 365 and Office | Excel | Other | Other
0 comments
Answer accepted by question author
Alexandr S 106.6K Reputation points Independent Advisor
2026-10-02T18:29:29.7566667+00:00

Hello, christopher ritzau.

If names are in Column A and Column B, put this in C2

Please specify, should I fill in C2 if the names in A and B match? Or just if there are any names in A and B? Describe the condition in more detail.

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest

  1. AI answer

    2026-10-02T17:10:48.51+00:00

    In C2, use either of these formulas to combine the names from columns A and B with a space between them:

    • =A2&" "&B2
    • =CONCAT(A2," ",B2)

    If Flash Fill is preferred instead of a formula:

    1. Type the full name manually in C2.
    2. Start typing the next full name in C3.
    3. Press Enter to accept the preview, or use Data > Flash Fill or Ctrl+E.
    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.