G
Guest
Am trying to figure out if a user-defined function can be created to
alphabetically re-order a text with multiple words.
For example.
"Hotel Paris Hilton" should convert to "Hilton Hotel Paris"
"Paris" is then the last word because "H" is before "P" in the alphabet
"Hilton" is the first word because "i" is before "o" in the Alphabet and so
on and so forth.
For any help I would be really grateful.
Thanks
Mike
alphabetically re-order a text with multiple words.
For example.
"Hotel Paris Hilton" should convert to "Hilton Hotel Paris"
"Paris" is then the last word because "H" is before "P" in the alphabet
"Hilton" is the first word because "i" is before "o" in the Alphabet and so
on and so forth.
For any help I would be really grateful.
Thanks
Mike