Posted to microsoft.public.excel.misc

kyoshirou

external usenet poster

Posts: 133

CONCATENATE

Hello,

Can i ask when i used CONCATENATE, how many fields can i CONCATENATE up to?
For example, i can only CONCATENATE from E2,E3,E4,.... to AH..

if i continue to CONCATENATE AI onwards, excel prompt me error.

How do i solve it? i would like to further CONCATENATE till AZ.

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	Wanna Learn	Excel Discussion (Misc queries)	6	October 4th 07 03:51 PM
Concatenate	Cassie	Excel Worksheet Functions	8	August 4th 07 11:44 PM
Concatenate	RChicken	Excel Discussion (Misc queries)	2	July 11th 06 03:00 PM
IF, IF, Concatenate?	savvysam	Excel Worksheet Functions	6	August 3rd 05 11:16 PM
I know how to concatenate ,can one de-concatenate to split date?	QUICK BOOKS PROBLEM-	New Users to Excel	1	July 26th 05 05:07 PM

All times are GMT +1. The time now is 07:00 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us