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

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

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

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