Re: Excel help needed
Posted 4/4/2014 10:30:21 AM by deedee1013


Posted 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.



If they are all in the same cell...

Remove Blanks
Print Post      Close Window