Hello, I am trying to extract abbreviations from a string of words and display them in a new cell.
The abbreviations are as follows:
Wheat; W
Dairy; D
Egg; E
Fish; F
Shellfish; SH
Soy; S
Peanut; P
Tree Nut; TN
Vegan; VGN
Vegetarian; V
The Strings can be any combination of any or all of these in a single cell as follows (commas and all):
Wheat, Dairy, Egg, Soy, Vegetarian
or simply
Vegan
I can hide columns or use a back sheet, but it has to be automatic (for people who really dont know how to use excel), and without VBA (security wont allow VBA to pass through email.)
Can anybody help!!!?
I had someone suggest a comma delimited separation into columns, and then abbreviate, and then concatenate them but it isn't foolproof enough, or automatic.
Thanks in advance for anybodys suggestions!
-Alex
The abbreviations are as follows:
Wheat; W
Dairy; D
Egg; E
Fish; F
Shellfish; SH
Soy; S
Peanut; P
Tree Nut; TN
Vegan; VGN
Vegetarian; V
The Strings can be any combination of any or all of these in a single cell as follows (commas and all):
Wheat, Dairy, Egg, Soy, Vegetarian
or simply
Vegan
I can hide columns or use a back sheet, but it has to be automatic (for people who really dont know how to use excel), and without VBA (security wont allow VBA to pass through email.)
Can anybody help!!!?
I had someone suggest a comma delimited separation into columns, and then abbreviate, and then concatenate them but it isn't foolproof enough, or automatic.
Thanks in advance for anybodys suggestions!
-Alex