One way to do this is use the following function.

'-------------------------------------
Function splitText(r As Range, s As String, col As Byte)
    Dim txt As String
    Dim c
    txt = r.Value
    c = Split(txt, s)
    splitText = c(col - 1)
End Function
'-------------------------------------

in cell B1 put  the formula splitText(A1,",",1)
similarly, in cell C1 put  the formula splitText(A1,",",2)
and so on.


Akhilesh Kumar Karna



On Thu, Nov 20, 2008 at 12:13 AM, Mike <[EMAIL PROTECTED]> wrote:

>
> Hi,
> i have a data populated into a column with company name and other data
> devided by a comma.
>
> So it looks something like:
>
> AAA Inc., Series1
> ABCD Ltd., Class 99
> 1234 Bank, Some Data 999
> and so on
>
> How could i put everything to the left from comma to column B and
> everything to the right from comma to column C?
> Thanks very much.
> Mike
>
>
>
>
>
> >
>

--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/excel-macros?hl=en

Visit & Join Our Orkut Community at 
http://www.orkut.com/Community.aspx?cmm=22913620

Visit the blog to download Excel tutorials at 
http://www.excel-macros.blogspot.com

To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com

To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---

Reply via email to