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
|