how to delete space between characters or number in a openoffice cell


How to delete space between characters or number in a openoffice cell.
Searched a lot and finally got the answer like this ..

Suppose you have these kind of requirement then

  • A1 cell 111 222 333 will be 111222333
  • A1 cell Hey whats up will be Heywhatsup

For TEXT Use :
=SUBSTITUTE(A9," ","")

For NUMBERS Use :
=–SUBSTITUTE(A9," ","")

Happy Calc.

One Comment

  1. Paul Mellor
    Posted December 20, 2011 at 7:25 pm | Permalink | Reply

    Works well thank you.
    Only change is use ; for openoffice and not ,

    Does anyone know the formula for multiple substitutions please ?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: