Want to extract specific data to another cell in Excel

Multi tool use
Multi tool use












-2















000008()-24/25 MELFORD COURT, HARDWICK GRANGE WOOLSTON WARRINGTON, WAI 4RZ ENGLAND


I want to extract all data i.e. the whole address after 000008()- in another cell in Excel but don't know how to do it










share|improve this question




















  • 1





    Can you show some more sample data. A formula may work on this string but may not work on others. It would be better to show some more samples to generalize the formula

    – usmanhaq
    Nov 24 '18 at 6:10






  • 2





    Why the Access tag? Can it be removed as not sure relevant. If you always want the string after the first - there are lots of examples of this on StackOverflow using functions like Find/Search combined with other string functions (Left,Right, Mid, Len....)

    – QHarr
    Nov 24 '18 at 7:01








  • 2





    show us what you have tried

    – Ivan Vinogradov
    Nov 24 '18 at 7:53











  • 000009 ( ) - ABDUL QADIR MANSLON, HUSBAND ROAD, PUNJABI CLUB, KHARADAR, KARACHI 000007 ( ) - CS-49, SHOP # 02 PRINCE 000014 ( ) - (64) 11/A, AL NOOR AUTO MARKET, PLAZA SQUARE ( PREEDY ST. ) SADDAR, KARACHI. NA A.B. TRADERS Karachi 021-2727313/272303 021-2726752/2773322 No 000015 ( ) - FL-1/11, 2ND FLOOR, ALEEM

    – Jalil Cracker
    Nov 25 '18 at 9:53











  • As per the data you have provided i can come up with this, if the rest of your data is different than the provided one, the formula may not work.. =TRIM(MID(A2,FIND("-",A2)+1,LEN(A2)-FIND("-",A2))) It is extracting the address from the cell A1

    – usmanhaq
    Nov 26 '18 at 6:11
















-2















000008()-24/25 MELFORD COURT, HARDWICK GRANGE WOOLSTON WARRINGTON, WAI 4RZ ENGLAND


I want to extract all data i.e. the whole address after 000008()- in another cell in Excel but don't know how to do it










share|improve this question




















  • 1





    Can you show some more sample data. A formula may work on this string but may not work on others. It would be better to show some more samples to generalize the formula

    – usmanhaq
    Nov 24 '18 at 6:10






  • 2





    Why the Access tag? Can it be removed as not sure relevant. If you always want the string after the first - there are lots of examples of this on StackOverflow using functions like Find/Search combined with other string functions (Left,Right, Mid, Len....)

    – QHarr
    Nov 24 '18 at 7:01








  • 2





    show us what you have tried

    – Ivan Vinogradov
    Nov 24 '18 at 7:53











  • 000009 ( ) - ABDUL QADIR MANSLON, HUSBAND ROAD, PUNJABI CLUB, KHARADAR, KARACHI 000007 ( ) - CS-49, SHOP # 02 PRINCE 000014 ( ) - (64) 11/A, AL NOOR AUTO MARKET, PLAZA SQUARE ( PREEDY ST. ) SADDAR, KARACHI. NA A.B. TRADERS Karachi 021-2727313/272303 021-2726752/2773322 No 000015 ( ) - FL-1/11, 2ND FLOOR, ALEEM

    – Jalil Cracker
    Nov 25 '18 at 9:53











  • As per the data you have provided i can come up with this, if the rest of your data is different than the provided one, the formula may not work.. =TRIM(MID(A2,FIND("-",A2)+1,LEN(A2)-FIND("-",A2))) It is extracting the address from the cell A1

    – usmanhaq
    Nov 26 '18 at 6:11














-2












-2








-2








000008()-24/25 MELFORD COURT, HARDWICK GRANGE WOOLSTON WARRINGTON, WAI 4RZ ENGLAND


I want to extract all data i.e. the whole address after 000008()- in another cell in Excel but don't know how to do it










share|improve this question
















000008()-24/25 MELFORD COURT, HARDWICK GRANGE WOOLSTON WARRINGTON, WAI 4RZ ENGLAND


I want to extract all data i.e. the whole address after 000008()- in another cell in Excel but don't know how to do it







excel excel-formula excel-2010






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 24 '18 at 12:01









Lee Mac

5,40531643




5,40531643










asked Nov 24 '18 at 5:57









Jalil CrackerJalil Cracker

21




21








  • 1





    Can you show some more sample data. A formula may work on this string but may not work on others. It would be better to show some more samples to generalize the formula

    – usmanhaq
    Nov 24 '18 at 6:10






  • 2





    Why the Access tag? Can it be removed as not sure relevant. If you always want the string after the first - there are lots of examples of this on StackOverflow using functions like Find/Search combined with other string functions (Left,Right, Mid, Len....)

    – QHarr
    Nov 24 '18 at 7:01








  • 2





    show us what you have tried

    – Ivan Vinogradov
    Nov 24 '18 at 7:53











  • 000009 ( ) - ABDUL QADIR MANSLON, HUSBAND ROAD, PUNJABI CLUB, KHARADAR, KARACHI 000007 ( ) - CS-49, SHOP # 02 PRINCE 000014 ( ) - (64) 11/A, AL NOOR AUTO MARKET, PLAZA SQUARE ( PREEDY ST. ) SADDAR, KARACHI. NA A.B. TRADERS Karachi 021-2727313/272303 021-2726752/2773322 No 000015 ( ) - FL-1/11, 2ND FLOOR, ALEEM

    – Jalil Cracker
    Nov 25 '18 at 9:53











  • As per the data you have provided i can come up with this, if the rest of your data is different than the provided one, the formula may not work.. =TRIM(MID(A2,FIND("-",A2)+1,LEN(A2)-FIND("-",A2))) It is extracting the address from the cell A1

    – usmanhaq
    Nov 26 '18 at 6:11














  • 1





    Can you show some more sample data. A formula may work on this string but may not work on others. It would be better to show some more samples to generalize the formula

    – usmanhaq
    Nov 24 '18 at 6:10






  • 2





    Why the Access tag? Can it be removed as not sure relevant. If you always want the string after the first - there are lots of examples of this on StackOverflow using functions like Find/Search combined with other string functions (Left,Right, Mid, Len....)

    – QHarr
    Nov 24 '18 at 7:01








  • 2





    show us what you have tried

    – Ivan Vinogradov
    Nov 24 '18 at 7:53











  • 000009 ( ) - ABDUL QADIR MANSLON, HUSBAND ROAD, PUNJABI CLUB, KHARADAR, KARACHI 000007 ( ) - CS-49, SHOP # 02 PRINCE 000014 ( ) - (64) 11/A, AL NOOR AUTO MARKET, PLAZA SQUARE ( PREEDY ST. ) SADDAR, KARACHI. NA A.B. TRADERS Karachi 021-2727313/272303 021-2726752/2773322 No 000015 ( ) - FL-1/11, 2ND FLOOR, ALEEM

    – Jalil Cracker
    Nov 25 '18 at 9:53











  • As per the data you have provided i can come up with this, if the rest of your data is different than the provided one, the formula may not work.. =TRIM(MID(A2,FIND("-",A2)+1,LEN(A2)-FIND("-",A2))) It is extracting the address from the cell A1

    – usmanhaq
    Nov 26 '18 at 6:11








1




1





Can you show some more sample data. A formula may work on this string but may not work on others. It would be better to show some more samples to generalize the formula

– usmanhaq
Nov 24 '18 at 6:10





Can you show some more sample data. A formula may work on this string but may not work on others. It would be better to show some more samples to generalize the formula

– usmanhaq
Nov 24 '18 at 6:10




2




2





Why the Access tag? Can it be removed as not sure relevant. If you always want the string after the first - there are lots of examples of this on StackOverflow using functions like Find/Search combined with other string functions (Left,Right, Mid, Len....)

– QHarr
Nov 24 '18 at 7:01







Why the Access tag? Can it be removed as not sure relevant. If you always want the string after the first - there are lots of examples of this on StackOverflow using functions like Find/Search combined with other string functions (Left,Right, Mid, Len....)

– QHarr
Nov 24 '18 at 7:01






2




2





show us what you have tried

– Ivan Vinogradov
Nov 24 '18 at 7:53





show us what you have tried

– Ivan Vinogradov
Nov 24 '18 at 7:53













000009 ( ) - ABDUL QADIR MANSLON, HUSBAND ROAD, PUNJABI CLUB, KHARADAR, KARACHI 000007 ( ) - CS-49, SHOP # 02 PRINCE 000014 ( ) - (64) 11/A, AL NOOR AUTO MARKET, PLAZA SQUARE ( PREEDY ST. ) SADDAR, KARACHI. NA A.B. TRADERS Karachi 021-2727313/272303 021-2726752/2773322 No 000015 ( ) - FL-1/11, 2ND FLOOR, ALEEM

– Jalil Cracker
Nov 25 '18 at 9:53





000009 ( ) - ABDUL QADIR MANSLON, HUSBAND ROAD, PUNJABI CLUB, KHARADAR, KARACHI 000007 ( ) - CS-49, SHOP # 02 PRINCE 000014 ( ) - (64) 11/A, AL NOOR AUTO MARKET, PLAZA SQUARE ( PREEDY ST. ) SADDAR, KARACHI. NA A.B. TRADERS Karachi 021-2727313/272303 021-2726752/2773322 No 000015 ( ) - FL-1/11, 2ND FLOOR, ALEEM

– Jalil Cracker
Nov 25 '18 at 9:53













As per the data you have provided i can come up with this, if the rest of your data is different than the provided one, the formula may not work.. =TRIM(MID(A2,FIND("-",A2)+1,LEN(A2)-FIND("-",A2))) It is extracting the address from the cell A1

– usmanhaq
Nov 26 '18 at 6:11





As per the data you have provided i can come up with this, if the rest of your data is different than the provided one, the formula may not work.. =TRIM(MID(A2,FIND("-",A2)+1,LEN(A2)-FIND("-",A2))) It is extracting the address from the cell A1

– usmanhaq
Nov 26 '18 at 6:11












1 Answer
1






active

oldest

votes


















-1














=RIGHT(A1,LEN(A1)-9)


will achieve what you say you want.



enter image description here






share|improve this answer

























    Your Answer






    StackExchange.ifUsing("editor", function () {
    StackExchange.using("externalEditor", function () {
    StackExchange.using("snippets", function () {
    StackExchange.snippets.init();
    });
    });
    }, "code-snippets");

    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "1"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: true,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: 10,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });














    draft saved

    draft discarded


















    StackExchange.ready(
    function () {
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53455573%2fwant-to-extract-specific-data-to-another-cell-in-excel%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    -1














    =RIGHT(A1,LEN(A1)-9)


    will achieve what you say you want.



    enter image description here






    share|improve this answer






























      -1














      =RIGHT(A1,LEN(A1)-9)


      will achieve what you say you want.



      enter image description here






      share|improve this answer




























        -1












        -1








        -1







        =RIGHT(A1,LEN(A1)-9)


        will achieve what you say you want.



        enter image description here






        share|improve this answer















        =RIGHT(A1,LEN(A1)-9)


        will achieve what you say you want.



        enter image description here







        share|improve this answer














        share|improve this answer



        share|improve this answer








        edited Jan 4 at 3:41

























        answered Nov 24 '18 at 7:42









        pnutspnuts

        49k764101




        49k764101
































            draft saved

            draft discarded




















































            Thanks for contributing an answer to Stack Overflow!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid



            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.


            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53455573%2fwant-to-extract-specific-data-to-another-cell-in-excel%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            1,xg6MVwmOZlhXN3xx,uhZjLCKRarhXwPyB h4GeBll
            arBox37Hpc ELrnBln2QJS7JYhlR9I7 FifS9d4F xPKDXr0 CHTAkGZIM8FjY

            Popular posts from this blog

            Costa Masnaga

            Fotorealismo

            Sidney Franklin