merging text information

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

=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