B
BrendanC
I download a lot of docs that require reformatting to remove a lot of spaces
between words; then this is cut & paste via word into our database.
Is there an automated way to remove spaces between words? I have found a
macro to remove leading white space but not spaces between words (to leave
only one space between each word).
Note: the spaces b/w each word may vary. Here is an example of the text
before and after 'conversion' that is required:
'This has too many variable spaces
between words'
Desired result:
'This has too many variable spaces between words'
Thanks!
Brendan
between words; then this is cut & paste via word into our database.
Is there an automated way to remove spaces between words? I have found a
macro to remove leading white space but not spaces between words (to leave
only one space between each word).
Note: the spaces b/w each word may vary. Here is an example of the text
before and after 'conversion' that is required:
'This has too many variable spaces
between words'
Desired result:
'This has too many variable spaces between words'
Thanks!
Brendan