Excel help needed

Posted By Message

WannaBeAMom11
LIF Adult

Member since 1/11

7391 total posts

Name:
Name

Excel help needed

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.

Posted 4/4/14 10:24 AM
 
Long Island Weddings
Long Island's Largest Bridal Resource

Ian&EmmesMommy23
My family is complete!

Member since 11/08

12970 total posts

Name:
Diana

Excel help needed

are each of those numbers in its own cell?

in an empty cell you use concatenate. so it would be

=concatenate(A1,B1,C1)

Message edited 2014-04-04 10:29:56.220000.

Posted 4/4/14 10:29 AM
 

deedee1013
LIF Adolescent

Member since 11/07

616 total posts

Name:
Diane

Re: Excel help needed

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

Posted 4/4/14 10:30 AM
 

WannaBeAMom11
LIF Adult

Member since 1/11

7391 total posts

Name:
Name

Excel help needed

Yes. Same cell.

Posted 4/4/14 10:31 AM
 

WannaBeAMom11
LIF Adult

Member since 1/11

7391 total posts

Name:
Name

Excel help needed

Thank you. It worked.

Posted 4/4/14 10:45 AM
 
 

Potentially Related Topics:

Topic Posted By Started Replies Forum
excel help needed jillee03 2/15/12 2 Families Helping Families ™
If your house needed work.... beautyq115 5/17/05 13 Home
Health Insurance Question-Feedback NEEDED juju 5/16/05 4 TTC
Reasonable Sheetrock and Spackle person needed MommyofG 5/11/05 0 Business Helping Families
computer fixer needed dm24angel 5/11/05 0 Business Helping Families
Disney Advice Needed Suzanne 5/10/05 16 Travel & Vacations