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 NewITZone Your Own Question
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

I have a big table of parts # XXXXX I need to insert hyphens

Customer Question

I have a big table of parts # XXXXX I need to insert hyphen's in between alpha and numeric characters. All different length strings.

For example:

any ideas. I want a formula, not a VB person. Needs to be dummy proof.
Submitted: 4 years ago.
Category: Microsoft Office
Expert:  Jason Jones replied 4 years ago.

Hello and thank you for your question today. My name is Jason. I look forward to helping you today.

Can you please, upload a copy of a document that you would be using for this along with a quick description what how you want the results to look?

Please, be forewarned that the site is not secure:
- Click the following link:
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"
Customer: replied 4 years ago.

459826 -

You'll see in the file the s/b column. I need a hyphen put in between all numbers and letters. You'll see the example. The only special character is a "/" that needs to be replaced by a hyphen. But I can do that as a find replace function.


Are you a VB programmer? If it needs to be VB I just need to know how to run it.



Expert:  Jason Jones replied 4 years ago.

Thank you for the document Jim.

My day has just started and I will be here for the next 16 hours.

I will start on this now for you.
Customer: replied 4 years ago.

ok, good luck.

Expert:  Jason Jones replied 4 years ago.
Thank you.
Expert:  Jason Jones replied 4 years ago.
I have run out of ideas.

For this reason, I am opting out of the question and allowing another expert the chance to help.

I wish you luck,
- Jason
Customer: replied 4 years ago.
Will someone else pick this up?
Expert:  Jason Jones replied 4 years ago.


When that occurs, you will be notified by email.