vzachin
10-17-2008, 05:54 AM
hi,
i have a very odd question.
i need to have a cell populated with only blank or null spaces based on a number in a different cell or based on the length of strings in another cell.
for example, if cell H9 = "XXXX", then i need cell H12 = "4blankspaces";
if cell I7 = 6, then i need cell I13 = "6blankspaces"
(i don't want the literal 4blankspaces or 6blankspaces, just the blanks...
i couldn't input H12 = " " or I13= " " with the correct spaces)
is this possible?
thanks
zach
i have a very odd question.
i need to have a cell populated with only blank or null spaces based on a number in a different cell or based on the length of strings in another cell.
for example, if cell H9 = "XXXX", then i need cell H12 = "4blankspaces";
if cell I7 = 6, then i need cell I13 = "6blankspaces"
(i don't want the literal 4blankspaces or 6blankspaces, just the blanks...
i couldn't input H12 = " " or I13= " " with the correct spaces)
is this possible?
thanks
zach