Posted to microsoft.public.excel.misc

Shane Devenshire[_2_] Shane Devenshire[_2_] is offline

external usenet poster

Posts: 3,346

concatenate formula

Hi,

And if you are using the longer version
=CONCATENATE(A1," ",B1)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Tacklemom" wrote:

Hi there,

I am wondering how to include spaces in this formula. I am joining 2 cells
but want 2 blank spaces between the joined cells. Thanks
--
Donna

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Concatenate a formula	Steven	Excel Worksheet Functions	1	July 23rd 08 04:17 AM
Concatenate formula or &	Sam	Excel Discussion (Misc queries)	11	January 18th 07 09:54 PM
help with formula...if -- concatenate	sedonovan	Excel Discussion (Misc queries)	1	June 22nd 06 12:31 PM
Need help with concatenate formula	Terri	Excel Worksheet Functions	4	March 29th 06 11:47 PM
Evaluating results of a concatenate formula, as a formula	dodger	Excel Worksheet Functions	5	September 9th 05 01:55 PM

All times are GMT +1. The time now is 12:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us