Adding spaces to a cell

C

catalfamo1220

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
 
S

Special-K

=CONCATENATE(" ",A1)

Then I'd copy and paste the values over the top of the original column

Regards
Special-
 
S

starguy

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.

hope this will serve your purpose.
 
R

RagDyeR

Try this:

=REPT(" ",26)&A1

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"catalfamo1220" <[email protected]>
wrote in message

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
 
Top