I wish to move all the words in the rows of a Column, 1 space to the left,
how do I so?

Note: All the rows only have a single word.


Thank you

Hi,
Insert a column beside the column that contains the words then enter the
formula as follow

=" "&C4

Then highlight the column with the formulas, copy, go to the original column
, paste special values

After you can hide or delete the column with the formula

if this helps please click yes, thanks

"PL" wrote:

I wish to move all the words in the rows of a Column, 1 space to the left,
how do I so?

Note: All the rows only have a single word.


Thank you

If you are looking at indenting..try

FormatCellsAlignment tabenter 'Indent' as one..

OR

Click the 'Increase Indent' icon from the toolbar

If this post helps click Yes
---------------
Jacob Skaria


"PL" wrote:

I wish to move all the words in the rows of a Column, 1 space to the left,
how do I so?

Note: All the rows only have a single word.


Thank you