| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete single spaces
How can i delete a single space from a cell example 123 456, to 123456
I see the trim option and clean but does not do this simple? task Please help someone , Mark |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
delete single spaces
Hi Mark:
Pull-down: Edit Find and click the Replace tab Enter a single space in the find what field and enter nothing in the replace field. The touch replace all -- Gary''s Student "Mark R" wrote: How can i delete a single space from a cell example 123 456, to 123456 I see the trim option and clean but does not do this simple? task Please help someone , Mark |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
delete single spaces
=SUBSTITUTE(A1," ","")
Regards, Stefi €˛Mark R€¯ ezt Ć*rta: How can i delete a single space from a cell example 123 456, to 123456 I see the trim option and clean but does not do this simple? task Please help someone , Mark |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
delete single spaces
Thanks Stefi Have a good Day
"Stefi" wrote: =SUBSTITUTE(A1," ","") Regards, Stefi €˛Mark R€¯ ezt Ć*rta: How can i delete a single space from a cell example 123 456, to 123456 I see the trim option and clean but does not do this simple? task Please help someone , Mark |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
delete single spaces
You are welcome!
Stefi €˛Mark R€¯ ezt Ć*rta: Thanks Stefi Have a good Day "Stefi" wrote: =SUBSTITUTE(A1," ","") Regards, Stefi €˛Mark R€¯ ezt Ć*rta: How can i delete a single space from a cell example 123 456, to 123456 I see the trim option and clean but does not do this simple? task Please help someone , Mark |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
delete single spaces
If the spaces in your document are "nonbreaking" spaces (you can't see them
in Excel), you will need to: Select data (columns, rows, etc. where you want to remove ALL spaces. CTRL+H {Find what?} ALT+0160 (use Numpad numbers) {Replace with} [leave blank] Replace all. Search remainder of document? NO "Mark R" wrote: How can i delete a single space from a cell example 123 456, to 123456 I see the trim option and clean but does not do this simple? task Please help someone , Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove all spaces in a cell... | Excel Worksheet Functions | |||
| Copy column range of "single word" cells with spaces to a single c | Excel Discussion (Misc queries) | |||
| delete spaces | Excel Worksheet Functions | |||
| how do I delete a worksheet from my workbook | New Users to Excel | |||
| In a protected worksheet allow users to delete rows | Excel Worksheet Functions | |||
Linear Mode
