Moving of words in cells

  • Thread starter Thread starter PL
  • Start date Start date
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
 
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
 
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
 
Back
Top