| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing blank cells...
Cells B38:B90 either are blank or have text in them. I would like a formula
in cell I38 to find the first cell in B38:B90 with text in it and have that text entered into cell I38. I would like cell I39 to find the next cell in B38:B90 that has text in it and have that text entered into cell I39 and so on. Thanks for the help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting blank cells until value is reached | Excel Worksheet Functions | |||
| Excel inserted 0's in cells linked to blank cells | Excel Discussion (Misc queries) | |||
| pivot tables reports - altering display of (blank) cells | Excel Worksheet Functions | |||
| CONCATENATE problem with blank cells | Excel Discussion (Misc queries) | |||
| Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
Threaded Mode
