Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to insert a value in one cell into many cells
I am currently creating a formula/function to insert a value in once cell
into many cells using excel 2003 , for example: cell A1 has a value 100 000 000, and the value is going to be inserted, into B1,C1,D1,E1,F1,G1,H1,I1,J1.Each cell will only have one digit only so B1 will have 1, C1 will have 0, D1 will have 0 and for the rest of the cell will have the same thing instead of whole value.I tried this thing with the MID function and it works as long as the source value cell is 9 digits(filling the cell from the B1toJ1), it became my concern when I changed those value less then 9 digits,say 8 or 5 digits where the cell will receive the value are B1 to F1 if 5 digits or B1 to I1 if 8 digits, the rest of the cells are blank. Are there any possibilities, solutions if the inserted value can be started from C1 to J1 for 8 digits or F1 to J1 for 5 digits etc (less than 9 digits) instead of B1 to I1 (8 digits) or B1 to F1 for 5 digits? It would be great help and apprecition for any solution from you thanks Thomas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
copying cell names | Excel Discussion (Misc queries) | |||
Maintaining cell references when inserting cells elsewhere | Excel Discussion (Misc queries) | |||
How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |