Hi all Looking for a little guidance on extracting data within my report. I have this string: 13:54Lab Waiting Roomand I want to strip the time out, I only want to see the data that is returned after each date. Any ideas? Thanks so much!!

There is a space in there, it should be: 13:54 Lab Waiting Room...Thanks!

Assuming that the time is always 5 followed by a space (6 total) =Right(<field name>, len(<field_name> ) - 6 ) or to be more techical =Mid(<field_name>, InStr(1,<filed_name>," ") + 1, Len(<field_name>) - InStr(1,<filed_name>, " ") )

Assuming that the time is always 5 followed by a space (6 total) =Right(<field name>, len(<field_name> ) - 6 ) or to be more techical =Mid(<field_name>, InStr(1,<filed_name>," "), Len(<field_name> - (InStr(1,<filed_name>, " ")))

JHab That is awesome, thanks sooo much!!!