I have the following formula in Excel:
=IF(A5="File Start","File Creation DateTime = "&MID(C5,113,13),IF(A5="Start","Statement Date = "&MID(C5,65,8)&" | Opening Balance Date = "&MID(C5,88,8),IF(A5="Statement","Statement Date = "&MID(C5,65,8)&" | Value Date = "&MID(C5,108,8)&" | Booking Date = "&MID(C5,116,8),IF(A5="End","Statement Date = "&MID(C5,65,8)&" | Closing Balance Date = "&MID(C5,88,8),""))))
Which gives a result along the lines of:
Statement Date = 20110217 | Value Date = 20101126 | Booking Date = 20110218
What I would like it to look like is:
Statement Date = 20110217 | Value Date = 20101126| Booking Date = 20110218
or
Statement Date = 20110217 | Value Date = 20101126 | Booking Date = 20110218
Where the bold items in option 2 are different colours.