numbers in one sheet

[webmax]

Hi

Please find the attached file.

I have data in the row wise . with using of formula or through macro the number will come in the single cell followed by comma.
regards
Shahul

 

[Deepak]

Hi,

Either read this post

http://chandoo.org/wp/2014/01/13/combine-text-values-quick-tip/

or use a UDF.

Public Function COMBINE(a As Variant, Optional sep As String = "") As String
' Harlan Grove, Mar 2002
    Dim y As Variant
    If TypeOf a Is Range Then
        For Each y In a.Cells
            COMBINE = COMBINE & y.Value & sep
        Next y
    ElseIf IsArray(a) Then
        For Each y In a
            COMBINE = COMBINE & y & sep
        Next y
    Else
        COMBINE = COMBINE & a & sep
    End If
    COMBINE = Left(COMBINE, Len(COMBINE) - Len(sep))
End Function

 

[Deepak]

Or this too!!

http://chandoo.org/wp/2008/05/28/how-to-add-a-range-of-cells-in-excel-concat/

 

[VDS]

@Deepak,

I have a doubt, suppose I have different data in one cell followed by comma. So, how to reverse the function.


VDS

 

[webmax]

i tried but the macro is not working.

 

[Deepak]

@Deepak,

I have a doubt, suppose I have different data in one cell followed by comma. So, how to reverse the function.


VDS

Don't try to hijack another's post!
If u have issue then raise a new post.

 

[VDS]

Sure Sorry for the inconvenience.

VDS

 

[Deepak]

i tried but the macro is not working.

Hi,

Pls check with attached file.