Posted to microsoft.public.excel.misc

Bry

external usenet poster

Posts: 14

concatenate #N/A

Hi

I have a problem concatenating cells, all are formated as text but some have
been taken from another worksheet where the cells have come back with a #N/A
result, in instances where this happened then the concatenate also errors.
What im looking for is a way of concatenating everything that is in the
cells selected even if its a '#N/A' error.

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 Function	BenG	Excel Discussion (Misc queries)	3	September 21st 06 10:08 PM
use formatting from source cell in CONCATENATE function	zacarab	Excel Worksheet Functions	1	September 18th 06 11:25 PM
Concatenate question	nick	Excel Worksheet Functions	3	July 27th 06 11:40 PM
Concatenate	Jeff	Excel Discussion (Misc queries)	4	October 5th 05 04:39 PM
Concatenate cells without specifying/writing cell address individually	Hari	Excel Discussion (Misc queries)	4	January 3rd 05 06:05 PM

All times are GMT +1. The time now is 01:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us