Indirect(Left(Find(

[Tahas]

Hi guys,

Need help in extracting data by combining indirect function with Left and Find. Here is my data:
Indirect: Sheet1
Cell C45: Canada (150)
Formula Cell: B5
Challenge: To split Cell45 into two separate fields i.e. Canada and 150.

Please help!

Thanks,
Taha

 

[Joe4]

I think some of the details are unclear or incomplete.
So, is B5 the cell you want this formula in, or the cell that "Sheet1" is in to use in the INDIRECT portion?
Can you post post your INDIRECT function that returns the entire value, as-is, and then we can work from there?