Good evening,
Does anyone know how I can line up 3 sets of figures used in a CONCATENATE function please?
My formula is:
=CONCATENATE("01 = (M) ",TEXT('Main Table'!E8,"0")," - (B) ",TEXT('Bonus Table'!E8,"0")," - (Both) ",TEXT('Main & Bonus Table'!E8,"0"))
It produces this for example:
01 =...