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

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

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