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

=LEFT(F19,1)&G19&TEXT(E19,"yyyymmdd") This is my current

Customer Question

This is my current formula which will read:
However I need it to read:
I can't seem to figure out how to add the Proper function to make this work.
Can anyone help, please.
Submitted: 6 months ago.
Category: Microsoft Office
Customer: replied 6 months ago.
Never mind, I finally figured it out. I needed it ASAP and I been working on this since 6PM CST.
That's the code and I am so beyond relieved I got it as I need to have this finished by tomorrow at 7am.
What a birth.
Thanks anyways, your reply just took too long. Thought it would be faster.
Anyway, no problem now since I finally got it. HOURS later. I guess I am just a dumb to Excel formulas.
Wishing you a great night.
Expert:  Richard replied 6 months ago.
Hi there and welcomeReally sorry about the delay, it is usually picked up much much quicker.Is there anything else that I can assist you with at all?