=substitute(a1," ","")

will remove the space and keep it as text.

Maybe you could use Edit|Replace and then format the column the way you want???

Format|cells|number tab|Custom category
00000000000



danielle wrote:

Hi

I have a spreadsheet that has 07777 077777 in one cell and I need to
remove the space in the middle on the number before I can import it a
database.

I have been splitting the number into two with text to columns and then
using concatenate to merge them back together without the space in
between.

The only problem is that if the number has a 0 at the begining of the
second part of numbers like the one above when I do text to columns it
deletes the zero.

Does anyone have any other ideas??

Thanks

--
danielle
------------------------------------------------------------------------
danielle's Profile: http://www.excelforum.com/member.php...o&userid=19348
View this thread: http://www.excelforum.com/showthread...hreadid=378514

--

Dave Peterson