Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help
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.programming
|
|||
|
|||
help
You can do that with a formul if you wish. In the cell where you would like
the value add the formula (assuming row 1)... =A1 & B1 & C1 & D1 & E1 & F1 Which will concatenate all of the cell values together. Since 5 of the six are blank it will be just the text from the one populated cell. -- HTH... Jim Thomlinson " wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
help
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|