removing space from string

Hello,

i need to remove a space from the middle of a text string, ie,

12345 6789 or 123 456789 or 1234567 89

needs to show

123456789

the space will be at a random point in the text.

any ideas?

thanks reg

thanks old chippy,

is there a function that will do the same thing, as its part of a larger worksheet that runsautomatically.

thanks reg

thanks old chippy,

is there a function that will do the same thing, as its part of a larger worksheet that runsautomatically.

thanks reg

thanks old chippy,

its seems so simple,

thanks again reg