$$Excel-Macros$$ Re: Segregation of data on a button click in excel

2009-07-28 Thread Pinky Sangani
HI GUYS THANK U VERY MUCH RGDS PINKY On Jul 28, 1:14 pm, shannu shannu wrote: > Not like that, >   >  I want all the cell values to appear in one single cell. like this >   > eg in cell A10. >   > name > designation > subject matter expert > company name > contact number > address >   >    All

$$Excel-Macros$$ Deleting a String and inserting a comma in a particular column

2009-07-28 Thread Pinky Sangani
hi ppl In one of the cell i have a long string say Yes ABD YES NHU JUI NO TIO TIO NO JIK JIK YES JAK The desired output shud b like: ABD, NHU JUI, JAK I need 2 write a macro for the same please help Thanks & Regards Pinky --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ Segregation of data on a button click in excel

2009-07-27 Thread Pinky Sangani
HI i need this ASAP i have 1 long string in 1 of the cell in the worksheet where in i have 2 segregate the datas in it to various columns as in the THe String is like "YES ABC NO XYZ YES AGH NO HGT" AND IT DIFFERS IN VARIOUS COLUMN WHEREIN SOME COLUMN It IS "NO ABC YES XYZ..."KINDLY HELP ME 2 WITE

$$Excel-Macros$$ Segregation of data on a button click in excel

2009-07-27 Thread Pinky Sangani
HI i need this ASAP i have 1 long string in 1 of the cell in the worksheet where in i have 2 segregate the datas in it to various columns as in the THe String is like "YES ABC NO XYZ YES AGH NO HGT" AND IT DIFFERS IN VARIOUS COLUMN WHEREIN SOME COLUMN It IS "NO ABC YES XYZ..."KINDLY HELP ME 2 WITE