Inserting a charecter in a set number of columns to the right of a cell containing a number which fi
Posted by John on October 30, 2001 11:37 AM
Please help. I need to insert a "1" in a number of cells to the right of a cell in which there is a number denoting the number of columns to insert the "1" into. In other words if i type a 7 in column A, i then need the spreadsheet to insert a "1" in the 7 cells immediatly to the right. Can anyone help please? my brain is ready to explode with trying diferent logical expressions!