$$Excel-Macros$$ Re: devide column values into two columns

Hi, I think you can also use the "Text to column" function by giving the separator as ",". It will split the column into two by useing , as a separator.. Hope this help.. Regards, Dev On Thu, Nov 20, 2008 at 8:44 PM, Tom Jeffries wrote: > The attached Workbook contains a macro(SplitCol) that

$$Excel-Macros$$ Re: devide column values into two columns

yes thats a better idea rather than writing a macro... U shd sometimes try to do simple things simply!! On Thu, Dec 11, 2008 at 9:21 PM, Manisha Jain wrote: > U can also try without the macro... > > go to Data -> Text to columns -> Delimited -> next -> check the box beside > comma ->next -> next

$$Excel-Macros$$ Re: devide column values into two columns

U can also try without the macro... go to Data -> Text to columns -> Delimited -> next -> check the box beside comma ->next -> next-> ok On Thu, Nov 20, 2008 at 8:44 PM, Tom Jeffries <[EMAIL PROTECTED]> wrote: > The attached Workbook contains a macro(SplitCol) that does what you > describe. If

$$Excel-Macros$$ Re: devide column values into two columns

** ** *Use Text to Column, very easy, no macros.* On Thu, Nov 20, 2008 at 8:44 PM, Tom Jeffries <[EMAIL PROTECTED]> wrote: > The attached Workbook contains a macro(SplitCol) that does what you > describe. If you have any questions let me know. > Tom > > On Wed, Nov 19, 2008 at 10:13

$$Excel-Macros$$ Re: devide column values into two columns

Use text to columns: Steps: Select the data, click on "Data" in menu bar, then click on "Text to Columns", Choose "Delimited", Click "Next", Check "Comma", click "Next", Click "Finish" Done On Wed, Nov 19, 2008 at 8:43 PM, Mike <[EMAIL PROTECTED]> wrote: > > Hi, > i have a data populated into a

$$Excel-Macros$$ Re: devide column values into two columns

Dear Group Members, I wanted to create a line chart, but to set its X axes in a nonstandard way. To do that I inserted some empty cell between data. I got what I wanted. But this time line itself disappeared. Now I have data points only... Line is not shown. I don't know whether macros have someth

$$Excel-Macros$$ Re: devide column values into two columns

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

$$Excel-Macros$$ Re: devide column values into two columns

Dear all I am using Vista with Office 2007. I am getting error message When I save or save as any documentI am getting the following message: "Your changes could not be saved to XXX because of a sharing violation. Excel

$$Excel-Macros$$ Re: devide column values into two columns

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 '-

$$Excel-Macros$$ Re: devide column values into two columns

The attached Workbook contains a macro(SplitCol) that does what you describe. If you have any questions let me know. Tom On Wed, Nov 19, 2008 at 10: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

$$Excel-Macros$$ Re: devide column values into two columns

Look at Text-to-Columns It's on the data tab in Excel2007. I don't remember where it is in 2003 or office97 but that's what you're looking for. Paul - Original Message > From: Mike <[EMAIL PROTECTED]> > To: MS Excel & VBA Macros > Sent: Wednesday, November 19, 2008 10:13:32 AM > Subj