How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Pete Your Own Question
Pete
Pete, Computer Expert
Category: Microsoft Office
Satisfied Customers: 16555
Experience:  MS Office expert
30970729
Type Your Microsoft Office Question Here...
Pete is online now
A new question is answered every 9 seconds

I need to change a cell in excel.a1 has AS-BDAP-212I

Customer Question

I need to change a cell in excel. a1 has AS-BDAP-212 I need cell b1 to have DAP-212, c1 to have ASBDAP212, d1 to have BDAP-212
Submitted: 5 years ago.
Category: Microsoft Office
Expert:  Pete replied 5 years ago.

ITPeter :

Hello, I am Pete, and I'll be happy to answer your question today.

ITPeter :

In cell B1, you will need the following formula:
=MID(A1,5,3)&"-"&RIGHT(A1,3)

ITPeter :

In cell C1, you will need the following formula:
=LEFT(A1,2)&UPPER(MID(A1,4,4))&RIGHT(A1,3)

ITPeter :

In cell D1, you will need the following formula:
=UPPER(MID(A1,4,4))&"-"&RIGHT(A1,3)

ITPeter :

IFf you need any further assistance, just let me know.

Pete.

Related Microsoft Office Questions