I would like to take a merge field from an excel spreadsheet in MS Word;
<First_Name> <Last_Name>; and reduce it to the initial only then last
name in lower case. I can reduce to lowercase but not to the first
initial.

My Example would be:

John Doe becomes jdoe. 

This would be for use as a username. I would like to do this in MS Word.

---

Request for Question Clarification by maniac-ga on 06 Oct 2006 18:35 PDT

Hello Billy_mcskintos,

Hmm. The comment by "barneca" makes a good point - it would be easier
to accomplish this in Excel than as a post processing step in Word.
Would you accept a solution where you have a formula in a column (may
be hidden) that computes the first initial automatically in Excel from
the person's name?

  --Maniac

since the list of names is already in excel, why not do the truncating
and concatenating in excel, then transfer to word?

-cab