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 ?