Link to home
Start Free TrialLog in
Avatar of Seamus2626
Seamus2626Flag for Ireland

asked on

Joining text and cells with formatting

Hi,

I have attached a spreadsheet.

In BB56 there is the text i want from the corresponding cells in AF56:AZ56

So i know there formula where i can join these but am not sure how to put it together

If someone can put this together i can copy to the rest of my cells

Thanks!
EE.xlsx
Avatar of Rgonzo1971
Rgonzo1971
Hi,

pls try

=AF56&" income has "&IF(AJ56>=0,"increased ","decreased ")&TEXT(AJ56,"0%")&", broken down - NII is $"&TEXT(AM56,"#'##0")&"k, a change of "&TEXT(AN56,"0%")&" - FX inc is $"&TEXT(AO56,"#'##0")&"k, a change of "&TEXT(AR56,"0%")&" - Non FX income is $"&TEXT(AS56,"#'##0")&"k, a change of "&TEXT(AV56,"0%")&" and average balances are $"&TEXT(AW56,"#'##0")&"k, a change of "&TEXT(AZ56,"0%")&"."

Open in new window


Regards
Avatar of Seamus2626
Seamus2626
Flag of Ireland image

ASKER

Thats nearly perfect Rgonzo, it returns the below - the only thing is the $1'878 where it should read $1,878

Amazon income has increased 33%, broken down - NII is $1'878k, a change of 65% - FX inc is $1'437k, a change of 542% - Non FX income is $'412k, a change of -78% and average balances are $847'749k, a change of 29%.

Thanks
Seamus
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Seamus2626
Seamus2626
Flag of Ireland image

ASKER

Sweet, legend!!