Add Space To Cell Sums

's Computer Specifications

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

's Computer Specifications

=A1&" "&B1 and so on

Don't know what you mean by Sums? This will be text

--

Regards,

Peo Sjoblom

"JR" <(E-Mail Removed)> wrote in message
news:UfednUit-(E-Mail Removed)...
> 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
>
>

's Computer Specifications

Wroks perfect, Thanks JR
"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:eSGxYoz$(E-Mail Removed)...
> =A1&" "&B1 and so on
>
> Don't know what you mean by Sums? This will be text
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> "JR" <(E-Mail Removed)> wrote in message
> news:UfednUit-(E-Mail Removed)...
>> 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
>>
>>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sums from a cell on multiple worksheets	jtfalk	Microsoft Excel Programming	1	20th Oct 2009 07:19 PM
2 sums one cell?	phat al	Microsoft Excel Misc	2	8th Aug 2006 03:04 AM
need formula to add cell sums by color of cell	Brucet	Microsoft Excel Misc	2	29th Dec 2005 09:46 PM
duplicating sums from dragging a cell	Rob Tonks	Microsoft Excel Worksheet Functions	2	21st Apr 2004 10:08 AM
makro that sums every new number entered in cell	Mario	Microsoft Excel Programming	3	29th Oct 2003 09:50 PM