| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to remove space from a cell.
Your formula is replacing spaces with spaces
=SUBSTITUTE(A115," "," ") Try changing that to..the below (Note the different between the find string (" ") and replace string ("") =SUBSTITUTE(A115," ","") OR =SUBSTITUTE(A115,CHAR(32),) If this post helps click Yes --------------- Jacob Skaria "Munfarid" wrote: May be the following with help you to understand the issue: The cell A1 contain "4353495894385 ". When i use the formula =LEN(A1), the result is "18" but when i use the formula =SUBSTITUTE(A115," "," "), the result is also comes at '18'. The result should rather be '13'. This indicates that the later portion of the numberstring is appeared to be 'spaces' which the substitute formula is not recognising. I hope you got my point. If not, please advise. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove space in front of number in a cell? | Excel Worksheet Functions | |||
| Macro to remove space at front and end of a cell | Excel Discussion (Misc queries) | |||
| How to remove a space | Excel Discussion (Misc queries) | |||
| How do I remove a space infront of text in a cell? | Excel Discussion (Misc queries) | |||
| Function to remove a space from text in cell WITHOUT macro?? | Excel Worksheet Functions | |||
Threaded Mode
