combining data in multiple cells

bala_vb

Senior Member

Location: Hyderabad

Posts: 237

Quote:

Originally Posted by adkmayhem

is it possible to combine data from more than 2 cells without losing the data
from the cells? i know i can concatenate 2 cells, but what about data from 3
or more cells?

Just to let you know, CONCATENATE function takes 255 arguments.

CONCATENATE (text1,text2,...)

Text1, text2, ... are 2 to 255 text items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references.

all the best

__________________
Thanks
Bala

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
Combining multiple cells into one	marti	Excel Discussion (Misc queries)	3	October 22nd 09 08:52 PM
Combining data from multiple cells into one cell with commas	lawandgrace	Excel Discussion (Misc queries)	1	June 2nd 09 04:25 PM
Combining data from multiple cells into one cell.	Steelsilk	Excel Worksheet Functions	4	May 17th 07 06:54 PM
Combining Text from multiple cells under multiple conditions	KNS	Excel Worksheet Functions	2	June 15th 05 11:00 PM
Combining data (numeric format) in multiple cells into one cell (t	GNAC SID	Excel Discussion (Misc queries)	2	February 7th 05 04:09 PM

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

Menu

About Us