I am working on a project in which data is restricted to choices, and then records those choices in abreviated form, e.g.
Choice 1: blue green red
Abreviated: bl gr re
Choice 2: stitched stapled
Abreviated: sti sta
Choice 3: Type01 Type02 Type03
Abreviated: 01 02 03
The abreviated forms will be all stored in a single cell for each record (although seperate cells may be used for calculations)
Therefore, examples of the possible results of the choices could be:
blsti01 (for Blue, Stitched and Type01)
grsti03 (for Green, Stitched and Type03)
resta02 (for Red, Stapled and Type02)
I need to understand how to use the functions RIGHT, LEFT and LEN (as i believe these are what are needed), to create a system to pick the information back out from the combined abreviations...
By this I mean it should take 'blsti01' and be able to take the bl , sti and 01 back out. From this point, I am able to design the rest... Any help ??
Thanks for reading,
Edited by ChrisWright, 31 October 2006 - 01:56 PM.