ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Moving of words in cells (https://www.excelbanter.com/excel-discussion-misc-queries/237661-moving-words-cells.html)

PL

Moving of words in cells
 
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

Eduardo

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


Jacob Skaria

Moving of words in cells
 
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



All times are GMT +1. The time now is 07:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com