How is your data organised? First_name and Last_name in separate
cells? First_name and Last_name in one cell separated by a space?
Last_name and First_name in one cell separated by a comma and
space? ... ???

Pete

On Jul 25, 12:49*am, Darlie Mary <Darlie
wrote:
Need syntax to show first 3 letters of last name and first letter of first
name. Also if last name only has 2 letters, need to add a Z on end to make 3
letters.