| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
removing a single space in a cell
I offen encounter a problem to remove a single space either numeric/characters in a single cell manully at excel. e.g: 123 456 or to day.
Please help me how to do it with thanks. birdsting |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
removing a single space in a cell
=REPLACE(A1," ","")
On 8 Maj, 05:23, birdsting wrote: I offen encounter a problem to remove a single space either numeric/characters in a single cell manully at excel. *e.g: 123 456 or to day. Please help me how to do it with thanks. birdsting -- birdsting |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
removing a single space in a cell
I bet Jarek meant:
=substitute(a1," ","") Jarek Kujawa wrote: =REPLACE(A1," ","") On 8 Maj, 05:23, birdsting wrote: I offen encounter a problem to remove a single space either numeric/characters in a single cell manully at excel. e.g: 123 456 or to day. Please help me how to do it with thanks. birdsting -- birdsting -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
removing a single space in a cell
you won, Dave
;-) of course SUBSTITUTE sorry On 8 Maj, 13:44, Dave Peterson wrote: I bet Jarek meant: =substitute(a1," ","") Jarek Kujawa wrote: =REPLACE(A1," ","") On 8 Maj, 05:23, birdsting wrote: I offen encounter a problem to remove a single space either numeric/characters in a single cell manully at excel. *e.g: 123 456 or to day. Please help me how to do it with thanks. birdsting -- birdsting -- Dave Peterson |
|
#5
|
|||
|
|||
|
thanks a lot to solve this problem with a simply function which I drop it off.
Cheer! Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Space | Excel Worksheet Functions | |||
| Removing Space | Excel Discussion (Misc queries) | |||
| removing space and tabs in a cell | Excel Discussion (Misc queries) | |||
| removing a space between words in a cell | Excel Worksheet Functions | |||
| Removing a space within a cell | Excel Worksheet Functions | |||
Hybrid Mode
