Jan 03 2022 11:35 AM
Jan 03 2022 02:42 PM
Jan 03 2022 03:25 PM
It wouldn't be a formula; would be a VBA routine (or macro).
But " " is itself a character, and how will you differentiate between that, (" "), and " " and " " -- without the aforementioned dictionary to let you know that you've finished a word, the desired word, the word that was intended in the original randomly spaced sequences of letters and spaces, given that some words contain words, and some endings of words can combine with beginnings of others to make up new words.....
The point: mechanically removing spaces--especially when your original premise was that the spacing is irregular between characters--requires some artificial intelligence to recognize not only words but also meaning (from the context of the words that precede and follow any given sequence of letters that might, or might not, constitute a word)....
Your request might appear to be a simple one--and is, for a human being--but, like driving, is far more than a mechanical task.
Jan 04 2022 05:19 AM
Jan 04 2022 05:25 AM