VBA to concatenate Text and/or Numbers and/or dates etc

[donoteventry;removes;pam]

2003

What function(s) in VBA could I use to treat the contents of any cell as text, so that, I could
concatenate all of the information.

C1 = Chicago
D1 = is
E1 = 252
F1 = miles
G1 = 7/24/2006

Therefore:
A1 = C1&D1&E1&F1&G1 (Of course this formula does not work because the data is inconsistent)

Complicating matters is that columns C thru G can have any type of data.

Is this a hopless case?

Thanks EagleOne

 

[Dave Peterson]

In excel, you could use a formula like:
=c1 & " " & d1 & " " & e1 & " " & f1 & " " & text(g1,"mm/dd/yyyy")

If you wanted VBA, you could use J.E. McGimpsey's multicat user defined
function:
http://mcgimpsey.com/excel/udfs/multicat.html

You'll see that J.E. relies on the .Text property (not .Value).

and you'd use:
=multicat(c1:G1)

in your cell

 

[donoteventry;removes;pam]

Thanks David

In excel, you could use a formula like:
=c1 & " " & d1 & " " & e1 & " " & f1 & " " & text(g1,"mm/dd/yyyy")

If you wanted VBA, you could use J.E. McGimpsey's multicat user defined
function:
http://mcgimpsey.com/excel/udfs/multicat.html

You'll see that J.E. relies on the .Text property (not .Value).

and you'd use:
=multicat(c1:G1)

in your cell