How can I remove blank spaces from fields
Thanks, but neither of these seem to be working with my records (which are
email addresses) when I copy the values back into column A.
Any thoughts?
Regards
--
nozzaworld
"Mike H" wrote:
Hi,
Try this
=SUBSTITUTE(A1," ","")
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"nozzaworld" wrote:
Hi,
I have a column of fields with some duplications. I want to remove those
duplications but all of the duplicates have a space at the end of them so are
not recognised as being true duplicates.
My question is, how do I remove the spaces from my data?
e.g. so that the two fields below both read nozzaworld
nozzaworld
nozza world
Many thanks
--
nozzaworld
|