How to combine text from 3 cells into 1 cell

  • Thread starter Thread starter JOF
  • Start date Start date
try this if your text are in a column A
in B2
=A2&" "&A3&" "&A4

or if your text are in row 2
in D2
=A2&" "&B2&" "&C2

or use the function =CONCATENATE(A2," ", B2," ",C2)
adjust the range to suit yours

Hope this help
--
Pls provide your feedback by clicking the Yes button below if this post have
help you. This will help others to search the archives for result better.


Thank You

cheers, francis
 

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 combine text from 3 cells into 1 cell with space and ", bet 1
Different colors within on cell. 3
Excel Concatenate with line breaks but ignore blank cells 3
Group List by Values in Column A and combine related row values inColumn B into 1 Cell 7
Excel Need Countifs Formula Help 0
Combining Text From Cells 3
Excel: Combine contents from identical cells on multiple sheets. 1
Excel Sum numbers in cells that also contain text 34

Back
Top