+ Reply to Thread
Results 1 to 5 of 5

Left Right Simple and Quick, Thank You!!

  1. #1
    Registered User
    Join Date
    10-28-2016
    Location
    The Moon, Milkyway Galaxy
    MS-Off Ver
    2013
    Posts
    19

    Wink Left Right Simple and Quick, Thank You!!

    Hi Guys,

    Me again, though this time with something a little easier.
    Please Login or Register  to view this content.
    Woodcliff Lake, NJ 076777654 is the sample cell. Need
    | Woodcliff Lake | NJ | 07677 | 7654 |


    I'm guessing it has to do with left and right formulas, but I just can't get it to work with what I've searched on the web. Any help would amazing!!

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Left Right Simple and Quick, Thank You!!

    Hi DemRlesDoe,

    See the attached that does what you want (I hope).

    I keyed off the comma in your string and used Left, Mid and Right to extract what you need.

    Left Mid Right using Comma.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,215

    Re: Left Right Simple and Quick, Thank You!!

    Try : If your data in "A2"

    In "B2"
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    In "C2"
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    In "D2"
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    (Assuming your all data record with "NJ")

    In "E2"
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Left Right Simple and Quick, Thank You!!

    I didn't check Marvin's solution but since I worked on it i'll post mine here...
    so assuming your addresses are in cell A1.
    in B1 =LEFT(A1,SEARCH(",",A1)-1) will return Woodcliff Lake
    in C1 =MID(RIGHT(A1,SEARCH(", ",A1)-3),1,2) will return NJ
    in D1 =MID(RIGHT(A1,9),1,5) will return 07677
    in E1 =RIGHT(A1,4) will return 7654
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  5. #5
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Left Right Simple and Quick, Thank You!!

    Try

    C1
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Copy towards the cells

    Excel 2016 (Windows) 64 bit
    A
    B
    C
    D
    E
    F
    1
    Woodcliff Lake, NJ 076777654 Woodcliff Lake NJ 07677 7654
    2
    Sheet: Sheet1
    Last edited by shukla.ankur281190; 03-21-2018 at 03:18 AM.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Progress bar (%) hopefully simple and quick
    By Muzza86 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-16-2014, 12:56 PM
  2. Progress Bar (%) Hopefully quick and simple
    By Muzza86 in forum Excel General
    Replies: 16
    Last Post: 04-16-2014, 08:17 AM
  3. Quick simple question!
    By Dermot81 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-09-2006, 09:39 PM
  4. [SOLVED] Quick help with a simple function!
    By [email protected] in forum Excel General
    Replies: 4
    Last Post: 07-20-2006, 01:25 AM
  5. Quick hide bar on left side of spreadsheet/workbook
    By TheTaxClub in forum Excel General
    Replies: 3
    Last Post: 06-27-2006, 01:10 PM
  6. simple quick question
    By John in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2005, 11:05 AM
  7. Quick simple question
    By Penny_Pecker in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-31-2005, 10:09 PM

Tags for this Thread

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