Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default Concatenate

I would like to concatenate the following cells, only if they don't contain
the word FALSE.

H3 - Subordinations ,
H4 - FALSE
H5 - FALSE
H6 - Inventory Verification Cycle ,
H7 - FALSE
H8 - FALSE
H9 - FALSE
H10 - FALSE
H11 - FALSE
H12 - FALSE
H13 - FALSE
H14 - Advance Rates ,
H15 - FALSE
H16 - FALSE
H17 - FALSE
H18 - FALSE
H19 - FALSE
H20 - FALSE

--
Barb
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How can I concatenate a number and preserve the formatting? [email protected] Excel Worksheet Functions 1 October 30th 06 10:40 PM
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 Jeff Excel Discussion (Misc queries) 4 October 5th 05 04:39 PM
Using Concatenate inside a vlookup bmclean Excel Worksheet Functions 3 July 5th 05 09:29 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"