Extract numbers after specific text in a text string

  • Hi Friends,


    Need a small help in excel. In a cell I have multiple rows of data which includes text and numbers. I am trying to extract numbers after a specific text for eg :


    Data in a cell where I need to run the search say in cell A1:


    SUMMARY= AInitial#11
    NOTES=
    AInitial#11
    RCA#=2
    ================================================================
    ID= PIW0
    WORKDETAIL_SUBMIT_DATE= 2020-02-20 01:06:27 -0600
    TYPE= General Information
    Volume#222
    SUBMITTER= tp
    SUMMARY= AVolume#11
    NOTES=
    AVolume#12

    Search Result

    in Cell B1 RCA = 2
    in Cell C1 AVolume = 11
    in Cell D1 AVolume = 12
    in Cell E1 Volume = 222


    As per above example i want to extract any numbers after "RCA", “AVolume” “Volume” as shown above. The numbers can be vary in digits i.e. it can be 1 digit numbers or 4 or 6. Also, at times there is some other text in between (like # & =).


    Any formula to get result will be helpful please prefer formula instead of VBA, since i am not sure how to use VBA.


    Thanking all in advance 😊