Excel help needed
Posted 4/4/2014 10:24:14 AM by WannaBeAMom11

BHP 00 00 01

What is the formula I can use to make it BHP000001. I have a spreadsheet with 1000 line items where the numbers aren't together and I can't figure out the formula. Thanks.
Print Post      Close Window