View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Adding spaces to a cell

Try this:

=REPT(" ",26)&A1

--

HTH,

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

"catalfamo1220"
wrote in message
news:catalfamo1220.2b56yr_1153228205.7463@excelfor um-nospam.com...

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