About Us

Eduardo

try

=RIGHT(SUBSTITUTE(A1," ",""),256)

"nozzaworld" wrote:

It seems to work for short fields like removing the space from nozza world.
However, it does not seem to work with spaces at the end of emails e.g

Many thanks
--
nozzaworld

"Eduardo" wrote:

Hi,
could you please explain what is not working, Mike formula works for me when
the space is in the middle of the name

"nozzaworld" wrote:

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I autofill spaces in right justified fields?	Bob_Balch	Excel Discussion (Misc queries)	1	July 18th 08 04:42 AM
Trim function to remove blank spaces in Excel	Natty	Excel Discussion (Misc queries)	1	June 26th 08 03:31 PM
Custom Fields with spaces	[email protected]	Excel Discussion (Misc queries)	15	July 16th 07 10:09 AM
how do I remove leading spaces and leave the remianing spaces w	Debi	Excel Worksheet Functions	6	February 28th 07 03:29 PM
Add spaces for specific fields to paste in	Corey	Excel Discussion (Misc queries)	3	December 30th 05 10:22 PM

Menu

About Us