View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Moving of words in cells

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