Forum Discussion

Bao_Van's avatar
Bao_Van
Copper Contributor
Jan 02, 2024
Solved

Combine different formats into one cell

Hi, I am looking for a solution to combine different formats into one cell, i.e. I want to have an output that look like this: "incl. 8.1 % VAT from 1 January 2024". Whereas the percentage 8.1% is a ...
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jan 02, 2024

    Bao_Van 

     

     

    ="incl. " & TEXT(B1, "0.0%") & " VAT from " & TEXT(B2, "d mmmm yyyy")

     

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jan 02, 2024

Bao_Van 

 

 

="incl. " & TEXT(B1, "0.0%") & " VAT from " & TEXT(B2, "d mmmm yyyy")

 

 

Resources