I need to add 26 spaces to the beginning of each cell in my worksheet. Is there any automated method which will accomplish this?
Thanks!
-Mike Catalfamo
I need to add 26 spaces to the beginning of each cell in my worksheet. Is there any automated method which will accomplish this?
Thanks!
-Mike Catalfamo
=CONCATENATE(" ",A1)
Then I'd copy and paste the values over the top of the original column
Regards
Special-K
if you have blank sheet (no data in it) then use following method:
press Ctrl+H
Find what: leave it blank
Replace with: press space bar 26 times
press Replace All
second method (if you have data in your sheet)
press Shift+F11 (to insert new sheet)
then in any cell of anyother sheet (other than new sheet and one that you want to add spaces in) press space bar 26 times.
now in new sheet in cell A1 enter the following function.
=cell reference in which you have entered spaces&cell A1 of your data sheet.
i-e if you have entered spaces in cell B5 of sheet "Data" and you want to add spaces in each cell of sheet say "Data2", function will be (in new sheet):
=Data!B5&Data2!A1
copy this function to the range your data is spread in Data2 sheet.
now your data is in new sheet with 26 spaces at the beginning of each cell.
if you want to remove formulas and want to keep the data as values, in new sheet press Ctrl+A to select the sheet then press Ctrl+C to copy then right click on the selection and click paste special, choose values from window appeared then press ok. your formulas are turned to values.
hope this will serve your purpose.
Originally Posted by catalfamo1220
Last edited by starguy; 07-18-2006 at 10:10 AM.
Try this:
=REPT(" ",26)&A1
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
"catalfamo1220" <[email protected]>
wrote in message
news:[email protected]...
I need to add 26 spaces to the beginning of each cell in my worksheet.
Is there any automated method which will accomplish this?
Thanks!
-Mike Catalfamo
--
catalfamo1220
------------------------------------------------------------------------
catalfamo1220's Profile:
http://www.excelforum.com/member.php...o&userid=29458
View this thread: http://www.excelforum.com/showthread...hreadid=562437
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks