How to create blank spaces
 

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

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

How to create blank spaces
 

in a cell:
=a2&rept(" ",69)&c2

in code:
dim myStr as string
with worksheets("sheet1")
mystr = .range("a2").value & space(69) & .range("C2").value
end with

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

--

Dave Peterson

How to create blank spaces
 

OMG! It worked! It's amazing how quick it is to do things if you kno
the proper terminology!!!!!

THANK YOU SOOOOO VERY MUCH FOR ALL OF YOUR HELP!!!!!!!!

*doing happy dance*

I OWE YOU BIG TIME

--
denileig
-----------------------------------------------------------------------
denileigh's Profile: http://www.excelforum.com/member.php...fo&userid=3021
View this thread: http://www.excelforum.com/showthread.php?threadid=50254