use CONCATENATE
Thanks & Regards
On 1/22/09, Tobi Hammet wrote:
>
>
> This does not have to be a makro, if its possible.
>
> Source:
>
> A1:5
> A2:7
> A3:7
>
> what i want from this:
>
> B1: 5,7,7
>
> (those values seperated by kommas)
>
> so can it be done without a makro?
>
> >
>
--~--~-
A more general solution if you use a macro:
Function ConcatRange(r As Range) As String
Dim s As String
Dim c As Range
For Each c In r
s = s & c.Value & ","
Next
ConcatRange = Mid(s, 1, Len(s) - 1)
End Function
Tom
On Fri, Jan 23, 2009 at 2:34 AM, TEAMPL wrote:
>
>
if you want it done macro
range("b1") = range("a1") & "," & range("a2") & "," & range("a3")
On 1월22일, 오후7시05분, Tobi Hammet wrote:
> This does not have to be a makro, if its possible.
>
> Source:
>
> A1:5
> A2:7
> A3:7
>
> what i want from this:
>
> B1: 5,7,7
>
> (those values seperated by ko
Sure, you can do it without a macro.
if you want a space with the comma,
just use ", " instead of just the ","
=CONCATENATE(A1,",",A2,",",A3)
- Original Message
> From: Tobi Hammet
> To: MS EXCEL AND VBA MACROS
> Sent: Thursday, January 22, 2009 5:05:38 AM
> Subject: $$Excel-Macros
