+ Reply to Thread
Results 1 to 3 of 3

Pulling text data and dollar amount data from same cell

  1. #1
    Registered User
    Join Date
    04-25-2013
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Pulling text data and dollar amount data from same cell

    Hey everyone- here's what I'm looking to do:

    I have a list of customers. I'm currently tracking how many jobs we do for each customer by day and my formula adds the total jobs for each customer by month. That part is fine.

    What I'd like to do is add how much $ we charged for each of those jobs and total it for each customer per month the same way I'm totaling the number of jobs for each customer.

    So cells in my calendar table will look something like this: ALLD - $500.50
    I want to count "ALLD" as 1 job for ALLD (in one cell) and I want to count "$500.50" for 1 ALLD job (in another cell).

    Is this possible? Please help. Thanks!

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Pulling text data and dollar amount data from same cell

    Are you just asking to split the info in that cell? Let's say the cell is A1
    for customer
    =TRIM(LEFT(A1,SEARCH(A1,"-")-1))
    For money
    =TRIM(MID(A1, SEARCH(A1, "-")+1,50))+0
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    04-25-2013
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Pulling text data and dollar amount data from same cell

    Yes, that's exactly what I want to do...split the imformation into different cells so that ALLD data goes to one cell and the $500.50 goes to another...However the dollar amounts aren't in yet...I want the formula to be able to pull any dollar amount I put in

    Thanks Chemist

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1