Yes it is. But what is your identifier?
This is an example where it looks for the first space and takes everything to the right of the space which is identified by " ":
Right([NameofField],Len([NameofField])-InStr(1,[NameofField]," "))
HTH,
Beth Moffitt
|