| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying text only if the cell is not empty
I have a range set from a1 to a50 and want to collect data from each non
blank cell in that range, in turn, and paste it into another cell. Thansk for your help...is that a bit clearer? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying specific value in cell into next empty row on different sheet | Excel Discussion (Misc queries) | |||
| Text Overwriting next empty cell | Excel Discussion (Misc queries) | |||
| Copying Data to next available empty cell in cloum | Excel Worksheet Functions | |||
| Copy a string text to cell if another cell not empty | Excel Discussion (Misc queries) | |||
| Text wider than one cell is not displayed in the next empty cell | Excel Discussion (Misc queries) | |||
![Big Chris[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
