How to create blank spaces

[denileigh]

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

[GB]

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
>
>

[Dave Peterson]

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

[denileigh]

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

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

*doing happy dance*

I OWE YOU BIG TIME!