I have a range say A4:A200 in cell A3 is the date and in the range there is a
bunch of cells that have a 3 up to 7 character text that equate to a time,
event, who and where code. I need something that will take the code and put
that code in a oneliner

ie code is 11P4 one liner should read today's date the 11 = 11am the
P =practice and the 4 is who and because there no character after the 4 the
location is known as Courtice with each peice of info in the one liner going
in it's own seperate cell

any help on this would be appreciated