Posted to microsoft.public.excel.misc

Alain Dekker Alain Dekker is offline

external usenet poster

Posts: 12

Concatenate strings?

Simple question:

I have:
"Fred" in A1
"loves" in B1
"chocolate" in C1

How do I set up a formula (like A1+B1+C1) do that in D1 I get "Fred loves
chocolate"? Is there any way to add sapces in the formula, maybe A1+" "+B1+"
"+C1? I've tried all of the above, without success.

I'm using Excep 97.

Thanks,
Alain

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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 I have two text strings in cells but it wont work	paintsr	Excel Discussion (Misc queries)	1	January 23rd 09 04:30 PM
How to find number of pairs of strings from list of strings?	greg_overholt	Excel Worksheet Functions	5	January 27th 06 10:42 PM
concatenate strings	Gary''s Student	Excel Worksheet Functions	3	September 15th 05 05:25 PM
How can I count strings within strings	Paul W	Excel Worksheet Functions	4	June 14th 05 12:39 PM
space between text strings with concatenate	Jeff	Excel Discussion (Misc queries)	2	March 3rd 05 06:54 PM

All times are GMT +1. The time now is 05:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us