Forum Discussion
Copy a formula horiztonally (Row 1") that references text in only one column "Column A"
I have an excel sheet with text in Column A. I have a formula that I need to copy and paste on the first row (D1, F1, H1, J1, L1...) the formula references text only in column A (A1, A2, A3, A4, A5...
A 365 solution that avoids traditional spreadsheet techniques.
= TOROW(HSTACK(list, IF(LEN(list)>0, "")))
Note that E1 is part of the formula result and cannot be used to enter data.
An interesting formula in that it doesn't generate a spill error, but it was my intention to insert blank cells not remove them!