Column Spacing Help

[JoniJoni]

I have a column of data. I would like to space this out so that each value is separated by two spaces.

E.g.

1
2
3

-->

1


2


3

I can do this manually (by inserting two cells), but I wondered if there is a way to do this automatically?

(I have a column organised with the spaces immediately to the left of the column I want to change.)

[oeldere]

Try this one on a dummy of your sheet.

Please Login or Register  to view this content.

[JoniJoni]

Thank you. A friend also suggested this, which worked:

=IF((ROW(K1)-1)/3=INT((ROW(K1)-1)/3),OFFSET($K$2,ROW(L2)/3,0),"")