Thread: How to create blank spaces
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GB GB is offline
external usenet poster
  
Posts: 230
Default How to create blank spaces
Dim TotalText as string

TotalText = A2

For I = 1 to 69
TotalText = TotalText & " "
Next I

TotalText = TotalText & B2


"denileigh" wrote:


Does anyone know how to create blank spaces in fields or joins?

I need to either:

Join A2 & C2 with 69 blank spaces in between them

- OR -

Join A2 B2(putting the blank spaces in B2) & c2.

Thanks for any help!

Di


--
denileigh
------------------------------------------------------------------------
denileigh's Profile: http://www.excelforum.com/member.php...o&userid=30211
View this thread: http://www.excelforum.com/showthread...hreadid=502548


Reply With QuoteReply With Quote