Inserting multiple values within a single cell.

[maacmaac]

Is it possible to insert multiple values within a single cell. For example, I have the following in cell A1:

The sales load charged on this trade [5.01%] exceeds the recommended sales load [4.50%] determined by the higher of an aggregation of all household fund family holdings or the ROA or LOI amount associated with the trade. [$94,249.47].

From the above, I want to pull in 3 values; (1) 5.01% is from cell B1 (2) 4.50% is from cell B2 (3) $94,249.47 is from cell B3.

Thanks in advance for any comments.

[kraljb]

="The Sales.. ..this trade "&B1&" exceeds.. ..sales load "&b2&" determined by.. ..the trade. "&b3

Hope that helps...
John