| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I remove blank spaces from fields
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I remove blank spaces from fields
Hi,
I assume your information is in column A, then in another column enter =trim(A1) Overwrite column A with new column copying as value "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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I remove blank spaces from fields
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I remove blank spaces from fields
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I remove blank spaces from fields
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I autofill spaces in right justified fields? | Excel Discussion (Misc queries) | |||
| Trim function to remove blank spaces in Excel | Excel Discussion (Misc queries) | |||
| Custom Fields with spaces | Excel Discussion (Misc queries) | |||
| how do I remove leading spaces and leave the remianing spaces w | Excel Worksheet Functions | |||
| Add spaces for specific fields to paste in | Excel Discussion (Misc queries) | |||
Linear Mode
