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 Mark Taylor Your Own Question
Mark Taylor
Mark Taylor, Certified Public Accountant (CPA)
Category: Financial Software
Satisfied Customers: 1858
Experience:  Certified Public Accountant
93680669
Type Your Financial Software Question Here...
Mark Taylor is online now
A new question is answered every 9 seconds

Can you help with excel?? Or Quickbooks?

Customer Question

Can you help with excel?? Or Quickbooks?
Submitted: 8 months ago.
Category: Financial Software
Expert:  Mark Taylor replied 8 months ago.

Hi, my name is Mark. I would be happy to help you with your questions.

Customer: replied 8 months ago.
excel spreadsheet list. How do I get my list to be alphabetical order by last name. I know how to it by first but I can't remember how to do it by last name.
Customer: replied 8 months ago.
Also how do I enter credit card charges that are on the credit card statement that have to be itemized by company, or job?
Expert:  Mark Taylor replied 8 months ago.

For the Excel question, is the name in one cell?

Customer: replied 8 months ago.
Expert:  Mark Taylor replied 8 months ago.

Ok please give me a moment to prepare your response

Expert:  Mark Taylor replied 8 months ago.

If the names are ***** ***** a single sell the easiest way to sort this is to create a separate column with the last name. Assuming that the name is ***** ***** cell A-1 here is the formula to move the last name:

=RIGHT(A1,LEN(A1)-FIND(" ",A1,1))

Expert:  Mark Taylor replied 8 months ago.

Once you have a column of last names you could select both columns and sort by the last name column. If you wanted to you could also create a column for the first name.

Expert:  Mark Taylor replied 8 months ago.

For the credit card charges you would want to enter the expenses on the credit card register. You could assign these charges to a company or job.

Expert:  Mark Taylor replied 8 months ago.

For the first name you would use the following formula... LEFT(A1,FIND(" ",A1,1)-1)

Related Financial Software Questions