Sorry if this has been answered before. I looked and couldn’t find an answer.
I have very little experience with macros. I can record, save, etc., just cannot get it to do what I want.
I need a calc macro that will simply add a leading space to whatever text is in a cell.
I have many thousands of cells with text, and just need to be able to shift the text to the right by a leading space.
I have tried recording a macro but I can’t get it to do what I want.
Just need a simple macro.
You probably do not want to alter the data but the alignment instead. Select/mark the cell range and invoke menu Format → Cells (or press Ctrl+1), tab Alignment, in Text Alignment set Horizontal to Left and enter an Indent value, for example 3 pt, which is about one space in a proportional font.
Instead of the dialog you could also use the Increase Indent button from the toolbar that increments indentation by 10pt, if that isn’t too much.
If you really want to insert a leading space in each cell (doubtful) then select/mark the cell range and invoke menu Edit → Find & Replace… (or Ctrl+H) and
- Find:
^ - Replace:
- under Other options enable
- Current selection only
- Regular expressions
To quickly select a known cell range go to the Name Box (Shift+Ctrl+T) and input the range, for example A1:A9999 and hit Enter.
Thank you very much. Recorded the macro as suggested and it worked. You have saved me a lot of anguish. Many thanks!
Apparently as a newcomer I do not have enough points to up-vote, but will do so when I am able to.