In excel make a formula In H2 we want to change the market cap values to show values as trillions, billons or millions with one decimal place. Like 12.3M or 5.3B or 578.1B or 999.9T, etc. Use two IF statements (nested). If the length of the market cap value is greater than 12, then handle for trillions, otherwise if the length of the market cap value is greater than 9, then handle for billions, otherwise handle for millions. Use text parsing to pull the values that we want then concatenate them together to get the required result. Along with the two IF statements mentioned directly above you can only use LEN, LEFT, MID and & to concatenate (each may be used multiple times). Refer only to G2. (H3 will refer to G3, H4 to G4 etc.) This is not a dynamic array