OdiN
08-13-2007, 09:04 AM
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.
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.