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 |
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 |
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