Concatenate and spaces

Sam40mUK · Apr 21st, 2002, 02:34 PM

Evening All,
A quick question .. I am Concatenating text from various cells and I would really like a Space between each.
Is this possible?
Thanks in advance.
S

Aladin Akyurek · Apr 21st, 2002, 02:37 PM

Quote:

On 2002-04-21 13:34, Sam40mUK wrote:
Evening All,
A quick question .. I am Concatenating text from various cells and I would really like a Space between each.
Is this possible?
Thanks in advance.
S

Try:

=A1&" "&B1&" "&C1

Sam40mUK · Apr 21st, 2002, 02:54 PM

Aladin,
Works fine, thanks.
For the benefit of others, note that a space is required between the two ""
I have to confess I did not notice that, at first!
Impetuous youth!
Cheers
S

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 21st, 2002, 02:34 PM	#1
Sam40mUK Board Regular Join Date: Mar 2002 Location: North Wales Coast, UK Posts: 95	Evening All, A quick question .. I am Concatenating text from various cells and I would really like a Space between each. Is this possible? Thanks in advance. S

Apr 21st, 2002, 02:54 PM	#3
Sam40mUK Board Regular Join Date: Mar 2002 Location: North Wales Coast, UK Posts: 95	Aladin, Works fine, thanks. For the benefit of others, note that a space is required between the two "" I have to confess I did not notice that, at first! Impetuous youth! Cheers S