Can you give a bit more detail about the 3-7 character text items.

I'm assuming you can have something like 1P4 meaning 01:00 a.m., but
how do you get up to 7 characters?

Is the "P" code always a one character or more? and how many codes are
there in this position.

Similarly with the "4" code. how many people are there? up to 99 or
more?

Finally what is "Courtice". Is this always the same or is this to be
derived from a Lookup table based on the who?

Rgds


On Fri, 21 Oct 2005 05:49:11 -0700, Herman
wrote:

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

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________