I have a spreadsheet of account numbers.

There are 3 parts to an account number - each in it's own cell.

I need to make this into a single account number.

I'm using Concatenate(A1,A2,A3)

However, there are some accounts which have leading zeros. I tried applying a custom format to get the zeros to show, but they won't move over when I concatenate.

For example if I have the following account:

05 555 00555

When I concatenate I get 5555555 and what I need is 0555500555.

Is there an easy way to handle this? I was able to do a search/replace on a lot of them because they first numbers are standard. The others there are tons of values so I can't do that.