newk
08-22-2005, 03:02 AM
Hi,
I have a spreadsheet with a column that stores peoples initials and occassionally names.
For example:
E14 : 'DO'
E15 : 'DO, KN'
Now when I apply an autofilter it will offer me two choices 'DO' and 'DO, KN'.
I would like it to return two choices; 'DO' & 'KN'.
How can I input two seperate values into a cell and it register that they are two values.
Please help, thank you
newk
I have a spreadsheet with a column that stores peoples initials and occassionally names.
For example:
E14 : 'DO'
E15 : 'DO, KN'
Now when I apply an autofilter it will offer me two choices 'DO' and 'DO, KN'.
I would like it to return two choices; 'DO' & 'KN'.
How can I input two seperate values into a cell and it register that they are two values.
Please help, thank you
newk