splitting cell cointents (one more time)

Hu · Mar 30th, 2004, 10:48 AM

Hi!

I have following problem, which i would be pleased to have help with. i have a cell containing values separated by ";". i would like to have those seperate values to be indexed somehow (preferaby using a macro) so that i could use appropriate one for the further calculations.
let's suppose A1 contains following value "a;b;c;d;e" (except for ""). i would like to be able to reference to each one of the elements for use in Select Case statement. is that possible?

please can anyone give me assistance on this one?
please, please, please, please, pleeeeease...

respect
hu

ps i have Excel 2003

onlyadrafter · Mar 30th, 2004, 12:06 PM

Hello,

Without understanding what you are going to do with the data, could you not use DATA --> TEXT TO COLUMNS and then use the cell contents?

Hu · Mar 30th, 2004, 12:18 PM

Hi!

i am about to match/compare the data with a constant value.
ok. let's put it this way - A1 contains following data "15.05.;15.11.", which basically in this case means May 15 and November 15 (the dates can be as many as 12). What i need is take first portion of data (15.05.) then add a year (i. e. 2004. however, no trouble with that) and campare with one of the dates i input (weather it is manually or other way does not matter). if entered date ir greater than May 15 then the same comparison should be done with the NEXT value (in this case 15.11.) and so on...
i hope this is clear. if want any additional info please inform me.

and thank you very much for your help!!!
respect
hu

Mar 30th, 2004, 10:48 AM	#1
Hu Join Date: Apr 2003 Location: Latvia Posts: 56	splitting cell cointents (one more time) Hi! I have following problem, which i would be pleased to have help with. i have a cell containing values separated by ";". i would like to have those seperate values to be indexed somehow (preferaby using a macro) so that i could use appropriate one for the further calculations. let's suppose A1 contains following value "a;b;c;d;e" (except for ""). i would like to be able to reference to each one of the elements for use in Select Case statement. is that possible? please can anyone give me assistance on this one? please, please, please, please, pleeeeease... respect hu ps i have Excel 2003

Mar 30th, 2004, 12:06 PM	#2
onlyadrafter Join Date: Aug 2003 Location: England Posts: 4,584	Re: splitting cell cointents (one more time) Hello, Without understanding what you are going to do with the data, could you not use DATA --> TEXT TO COLUMNS and then use the cell contents? __________________ ------------------------- Hope this is helpful. ------------------------- only a drafter, but broadening my Excel knowledge.

Mar 30th, 2004, 12:18 PM	#3
Hu Join Date: Apr 2003 Location: Latvia Posts: 56	Re: splitting cell cointents (one more time) Hi! i am about to match/compare the data with a constant value. ok. let's put it this way - A1 contains following data "15.05.;15.11.", which basically in this case means May 15 and November 15 (the dates can be as many as 12). What i need is take first portion of data (15.05.) then add a year (i. e. 2004. however, no trouble with that) and campare with one of the dates i input (weather it is manually or other way does not matter). if entered date ir greater than May 15 then the same comparison should be done with the NEXT value (in this case 15.11.) and so on... i hope this is clear. if want any additional info please inform me. and thank you very much for your help!!! respect hu

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode