Converting from a decimal format to a concatenated format

Hello

I am trying to take a decimal for like "1.25" lbs to a format like this "1lbs 4oz".

If it is possible I want to be able to use it in two scenarios one where is just referencing a cell like =B3
and where is calculates a formula like =E5/F28......

I hope that was clear enough explanation.

Originally Posted by Rioran

Hello.

How about something like this?

Formula:

Please Login or Register  to view this content.

Thank you worked great is there a way to display the oz without the decimal point behind it meaning like 6oz and not 6.2 oz

Thank you so much