Excel help please.

  [email protected]© 18:38 12 Apr 2007
Locked

I have a column of numbers in A and about 1000 rows down. I have gaps in the numbers whch I want to close up e.g AB1234 567 890. What is the formula that I can enter in the first cell and fire it down to do the rest please?

  VoG II 22:12 12 Apr 2007

=SUBSTITUTE(A1,CHAR(32),"")

and copy the formula down.

  [email protected]© 17:16 13 Apr 2007

Thanks VoG could you quickly break down the formula as to how it works so I know for the future.

  VoG II 17:38 13 Apr 2007

=SUBSTITUTE(OriginalText,TextToRemove,TextToInsert)

OriginalText in A1

TextToRemove = space = ASCII character 32 click here

TextToInsert = "" i.e. nothing.

  [email protected]© 19:01 13 Apr 2007

Thanks VoG I got the hang of that now. I found that I could also use find/replace as I did 'find' spacebar to make a gap and 'replace' with nothing and that worked.

  VoG II 19:02 13 Apr 2007

Ah yes, but you did ask specifically for a formula ;o)

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment regarder des séries et talk-shows américains en France ?