Excel Function

Posted on 2011-04-20
Last Modified: 2012-06-27
How would you create a function for the following:

U R* PIZZA GARDEN        03/30U R* AUST


Online Payment 1020751849 To Karen XXX 02/01
Karen XXX

Thanks. I'm new to Excel functions.
Question by:barnesco
    LVL 43

    Accepted Solution

    You need to know where to pick the phrase from. I cannot see any definite pattern from the examples given.

    For the first one you can use

    =mid("U R* PIZZA GARDEN        03/30U R* AUST",6,12)

    if the string is in A2

    Similarly for the other you can have

    =mid("Online Payment 1020751849 To Karen XXX 02/01",30,9)
    LVL 24

    Expert Comment

    You need to explain the logic.
    LVL 12

    Expert Comment

    the best direct way to do it is to convert the cell to table using the space as seperator, and then take the cell you want to make it in a new cell using concatinate fuction

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Suggested Solutions

    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now