How to connect characters together in different cells?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In cell A1 = ABC;
In cell B1 = 123;
I would like to join both strings together, then
In cell C1 = ABC123

Does anyone know how to do it in excel?
Thank anyone for suggestion
Eric
 
=a1&b1

If you have numbers like 1 or 12 and want to see:
ABC001 or ABC012
you can use:
=a1&text(b1,"000")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to detect characters with a cell? 12
How to split number and text string to separate cells? 5
How to display minute format for a cell? 10
How to determine the value? 2
How to count the number of occurrence within string? 2
How to retrieve certain text from string? 5
How to set the formula? 4
How to display the value in different format? 7

Back
Top