Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Remove Spacing In A Cell
I am trying to eliminate spacing for a upc in a cell. For a example:
0 11111 22222 3 011111222223 I have tried Clean, Trim, & Substitute. Anyone have any answers or Ideas? Thanks, |
#2
|
|||
|
|||
Hi Span,
See David McRitchie's TrimAll page at: http://www.mvps.org/dmcritchie/excel/join.htm#trimall --- Regards, Norman "Span" wrote in message ... I am trying to eliminate spacing for a upc in a cell. For a example: 0 11111 22222 3 011111222223 I have tried Clean, Trim, & Substitute. Anyone have any answers or Ideas? Thanks, |
#3
|
|||
|
|||
For me
A1: 0 11111 22222 3 =SUBSTITUTE(A1," ","") worked, returned A1: 011111222223 Regards, Stefi €žSpan€ť ezt Ă*rta: I am trying to eliminate spacing for a upc in a cell. For a example: 0 11111 22222 3 011111222223 I have tried Clean, Trim, & Substitute. Anyone have any answers or Ideas? Thanks, |
#4
|
|||
|
|||
Hi Steffi,
For me A1: 0 11111 22222 3 =SUBSTITUTE(A1," ","") worked, returned A1: 011111222223 That depends on the nature of the space.Given that Span said: I have tried Clean, Trim, & Substitute. It would appear possible that the spaces in question are the HTML non-breaking space character (ASCII code 160). See the link that I provided in my response to Span. See particularly David McRitchie's TrimAll Macro and the accompanying notes thereto. --- Regards, Norman "Stefi" wrote in message ... For me A1: 0 11111 22222 3 =SUBSTITUTE(A1," ","") worked, returned A1: 011111222223 Regards, Stefi "Span" ezt írta: I am trying to eliminate spacing for a upc in a cell. For a example: 0 11111 22222 3 011111222223 I have tried Clean, Trim, & Substitute. Anyone have any answers or Ideas? Thanks, |
#5
|
|||
|
|||
Thanks Norman,
I see the point now. Regards, Stefi €žNorman Jones€ť ezt Ă*rta: Hi Steffi, For me A1: 0 11111 22222 3 =SUBSTITUTE(A1," ","") worked, returned A1: 011111222223 That depends on the nature of the space.Given that Span said: I have tried Clean, Trim, & Substitute. It would appear possible that the spaces in question are the HTML non-breaking space character (ASCII code 160). See the link that I provided in my response to Span. See particularly David McRitchie's TrimAll Macro and the accompanying notes thereto. --- Regards, Norman "Stefi" wrote in message ... For me A1: 0 11111 22222 3 =SUBSTITUTE(A1," ","") worked, returned A1: 011111222223 Regards, Stefi "Span" ezt Ă*rta: I am trying to eliminate spacing for a upc in a cell. For a example: 0 11111 22222 3 011111222223 I have tried Clean, Trim, & Substitute. Anyone have any answers or Ideas? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to remove or replace a carriage return character in a cell? | Excel Discussion (Misc queries) | |||
How do I remove all text in a cell after a specific character? | Excel Worksheet Functions | |||
Remove line break within cell | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
How can I remove a formula from a cell and still have the value? | Excel Worksheet Functions |