Share via

How do I merge two cells with different text, and keep both texts?

Anonymous
2025-05-09T12:13:22+00:00

I want to add the same word at the end of a current text. I want to do this in a lot of cells. Is there a function for this?

for example, EHT is to be added in the same cells as the text in the column to the left.

Antikroppar FRW Block 1 platta 1 EHT
Antikroppar FRW Block 1 platta 2 EHT
Antikroppar FRW Block 1 platta 3 EHT
Antikroppar FRW Block 1 platta 4 EHT
Antikroppar FRW Block 1 platta 5 EHT
Antikroppar FRW Block 1 platta 6 EHT
Antikroppar FRW Block 1 platta 7 EHT
Antikroppar FRW Block 1 platta 8 EHT
Antikroppar FRW Block 2 platta 1 EHT
Antikroppar FRW Block 2 platta 2 EHT
Antikroppar FRW Block 2 platta 3 EHT
Antikroppar FRW Block 2 platta 4 EHT
Antikroppar FRW Block 2 platta 5 EHT
Antikroppar FRW Block 2 platta 6 EHT
Antikroppar FRW Block 2 platta 7 EHT
Antikroppar FRW Block 2 platta 8 EHT
Antikroppar FRW Block 2 platta 9 EHT
Antikroppar FRW Block 2 platta 10 EHT
Antikroppar FRW Block 2 platta 11 EHT
Antikroppar FRW Block 2 platta 12 EHT
Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2025-05-09T12:48:16+00:00

    Hello.

    Welcome to the Microsoft Community.

    If you'd like to merge two Excel cells that contain different text and keep both values (like in your example appending "ETH" to the end of each text string in the adjacent cell), you can use a formula rather than the standard Merge Cells Option, which only keeps the leftmost value.

    Here's how you can do it:

    1. In a new column, use the formula: =A1&" "&B1 This will combine the text from cell A1 and B1 with a space in between.
    2. Drag the formula down to apply it to the rest of the rows.
    3. Once done, you can copy the new column and use Paste > Paste Values to keep just the merged text.

    Let me know how it goes.

    Best Regards,

    Daniel Coy
    Microsoft Community Support

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-05-12T17:12:02+00:00

    Hello again, Linda.

    I'm glad that the information I shared was helpful.

    I'll be here if you need further guidance.

    Best Regards,

    Daniel Coy
    Microsoft Community Support

    0 comments
  2. Anonymous
    2025-05-09T13:45:39+00:00

    Hi Daniel!

    Thank you so much for you answer, that was exactly what I wanted to do. It worked excellent.

    Kind regards Linda

    0 comments