trim ?

[eran3185]

hi
i have many rows , but i saw something strange:
when i want to delete all the spaces i want to use "trim" , but its not work
here is an examplle : <br> 1<sp>tea
when i make "trim" i get - <br> 1<sp>tea
how can i delete all the spaces ?

 

[bbott]

here is an examplle :
1<sp>tea
when i make "trim" i get -
1<sp>tea

What is the result that you're expecting? I don't see any spaces in your example.
</sp></sp>

 

[shg]

how can i delete all the spaces?

=substitute(a1, " ", "")