O
Otto Liebat
When I export a SharePoint List, which contains a Choice
field, to Excel the selected items are separated into one
Excel cell, separated by semicolons (
. All items after
the first are preceeded with a # character. Example:
contents of a cell where items 2,3,5,7 were selected
= choice2;#choice3;#choice5;#choice7
Any suggestions on how to write an Excel formula (or
Macro) to test for which items have been selected? In
Excel, multiple values separated by semicolons are
considered an Array, but I have been unable to
sucessfully use process this cell as an array.
I'm able to use the SEARCH function, to test whether a
string exists within the cell. However, I was trying to
use this an an array for easier processing.
field, to Excel the selected items are separated into one
Excel cell, separated by semicolons (
. All items afterthe first are preceeded with a # character. Example:
contents of a cell where items 2,3,5,7 were selected
= choice2;#choice3;#choice5;#choice7
Any suggestions on how to write an Excel formula (or
Macro) to test for which items have been selected? In
Excel, multiple values separated by semicolons are
considered an Array, but I have been unable to
sucessfully use process this cell as an array.
I'm able to use the SEARCH function, to test whether a
string exists within the cell. However, I was trying to
use this an an array for easier processing.