Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
once more - - -
I have a range of six cells in a row on my spread sheet. Five cells are empty
and one contains data. I would like to find the single cell that contains text and copy that text into a cell at the end of the row |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
once more - - -
"
wrote in message ... I have a range of six cells in a row on my spread sheet. Five cells are empty and one contains data. I would like to find the single cell that contains text and copy that text into a cell at the end of the row You could try =A1&B1&C1&D1&E1&F1 -- David Biddulph |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
once more - - -
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|