Hello guys,
I need help with completing the following task. My input field will have up to 9 alphabetic characters 'a b c d e f g h i' (but could be more or less). My output cell length is 9 chars but the input cell can be longer as there's a space between each letter. the input cell can be blank or one char 'a' or two 'a b' or three 'c f g', ...
I need a formula to replace each char by 1 and fill the rest with 0. The 1 should be placed at the code value index of each letter. For instance if I have 'a c', I should have 1 in the first and third positions '101000000' since a and c are first and third value of the alphabet respectively; 'b d' would return '010100000' as b and d are 2nd and 4th chars of the alphabet.
My file should look like this:
Input Output
a c 101000000
c d e 001110000
a h 100000010
b i 010000001
c f h 001001010
d i 000100001
b d 010100000
Thanks
I need help with completing the following task. My input field will have up to 9 alphabetic characters 'a b c d e f g h i' (but could be more or less). My output cell length is 9 chars but the input cell can be longer as there's a space between each letter. the input cell can be blank or one char 'a' or two 'a b' or three 'c f g', ...
I need a formula to replace each char by 1 and fill the rest with 0. The 1 should be placed at the code value index of each letter. For instance if I have 'a c', I should have 1 in the first and third positions '101000000' since a and c are first and third value of the alphabet respectively; 'b d' would return '010100000' as b and d are 2nd and 4th chars of the alphabet.
My file should look like this:
Input Output
a c 101000000
c d e 001110000
a h 100000010
b i 010000001
c f h 001001010
d i 000100001
b d 010100000
Thanks