Clipping text in field to show 1 letter

[CreepyCody]

Hope this doesn't make me sound too much like a newbie, but:

I have a list of names that I import from Excel as First Name and Last Name. I need to make a merged name for labeling purposes. Ex:

Derek Jeter----->jeter.d

There is other info at the end, but this is where my problem is.

Can I define the First Name field to have a maximum of 1 character no matter what is imported?

Sorry if this just way too simple, and TIA

Creepy

[CreepyCody]

I'm an idiot...got it.

Thx to all the time I may have wasted

[bobsmith]

No idiots here otherwise you couldn't ask the questions.

RightWords(name,1) &"." & Left(name,1)

Using your example this name= Derek Jeter

The calculation takes the right word "Jeter" adds . and the first letter of the left word or the first name. If all names are two words no problem but if there are different number of words in different records you may have to make some adjustments.