Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Screening values in cells to create a sentence..
I am trying to write a macro that will insert values from different cells
into a sentence. The problem is that not all cells will have a value in them. Do you have a suggestion that does this? Here's what I mean as an example: Cell A1: paint Cell B1: nails Cell C1: null Cell D1: screws Cell E1: null Here is the sentence: This store carries the following goods: paint, nails, and screws.... As you can see from the example, I need to skip the cells with the null values. Any help would be much appreciated€¦ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrap long sentence in multiple cells | Excel Discussion (Misc queries) | |||
Strip Values From Cells To Create New Cell Value | Excel Discussion (Misc queries) | |||
How do i add a cell value in a sentence without using 2 cells? | Excel Worksheet Functions | |||
Screening Data | Excel Programming | |||
Combining text and cell value to create a sentence | Excel Discussion (Misc queries) |