Add Space To Cell Sums

  • Thread starter Thread starter JR
  • Start date Start date
J

JR

Hello,

I need to have a space added when combining cells.

Example: A1&B1&C1, but the output I get is 123, but I would like it to be 1
2 3, a space between numbers.

Thanks JR
 
=A1&" "&B1 and so on

Don't know what you mean by Sums? This will be text
 
You must log in or register to reply here.

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

Lookup function to cell containing multiple values 3
Show other cell if blank 5
Stop Rounding Currency 20
bug with cell in excel 7
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
making cells uncopyable 1
Combing Cell Values 2
Combining Info Fom Cells 7

Back
Top