Thread: Insert Space

I have a row(has data) in excel with an empty row(empty cell) below, now in the empty cell below I want to insert spaces as long(length of the data) as the row above. How do i do that ? Help me, Thanks.

Hi

Assuming your data starts in A1, then select your range from A1, to the cell after the last entered item. Edit, Go To, special, blanks. Enter the formula =REPT(" ",LEN(A1)), and press CTRL and Enter. Highlight column A, copy, edit pastespecial values.

HTH

rylo