View Single Post
  #12   Report Post  
Max
 
Posts: n/a
Default How to insert a value in one cell into many cells

"Thomas" wrote:
Just try to figure out why the formula shows nothing
(blank cell) when it is copied to another cells
such as L1 or AA1 (it does not show any result)


Simply because MID(...) would return: "" (empty text)
as the start_num* would evaluate to a figure greater
than the length of text in A1

*start_num part:
... COLUMN()-1+LEN(SUBSTITUTE($A1," ","")+0)-9 ..

The "max" length of the value in A1 was given in the orig. post as 9 digits,
so the decomposition by the formula was across a max of 9 cols (from the
starting cell B1 copied across to J1)

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--