Hi there,
You can seperate this data by using convert text to column wizard-> choose
option "delimited"-> then choose "next " -> the select delimiters "comma"
->then choose column data format "General" then "finish". You will get this
data
AAA Inc. Series1 ABCD Ltd. Class 99 1234 Bank Some Data 999
regards,
CB
On Wed, Nov 19, 2008 at 8:43 PM, 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
>
>
>
>
>
> >
>
--
Chandra Babu
Mob:-9971929146
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
