Moving of words in cells

P

PL

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
 
E

Eduardo

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
 
J

Jacob Skaria

If you are looking at indenting..try

Format>Cells>Alignment tab>enter 'Indent' as one..

OR

Click the 'Increase Indent' icon from the toolbar

If this post helps click Yes
 
Top