Dynamic heading, trying to combine data from multiple cells

[TheJay]

I have a heading and have been trying to combine two different pieces of data.

The formula at the moment is:

=IF(ISBLANK(C6),"",("Sample (50% Discount is "&TEXT(F4,"£0.000000")&(TEXT(F4*25%,"£0.000000")&")")))

This reads as:
Sample (50% Discount is £789.030000£197.257500)

I am trying to get it to say:
Sample (50% Discount is £789.030000) Sample 2 (25% off 50% Discount is £197.257500)

I've tried many combinations and just can't get it right, could someone please tell me what I should be adding?

Is there a way to use the values found within a cell containing text and data for calculations in others cells? If so, how is this done please?

Lastly, how can I format so that when the figure reaches over 1,000 it adds a comma in the thousands?

For example:
Sample (50% Discount is £2500.000000) Sample 2 (25% off 50% Discount is £625.000000)

Into:
Sample (50% Discount is £2,500.000000) Sample 2 (25% off 50% Discount is £625.000000)

Thanks for your help.

 

[Peter_SSs]

I'm afraid that I haven't either. I don't know what your existing formulas are doing/trying to do, I don't know what you mean by "somehow need to combine".
You referred to lower cells and higher cells but I have no idea what that mean or what any of your data is actually like.