Google Answers Logo
View Question
Q: format merge field in MS Word ( No Answer,   1 Comment )
Subject: format merge field in MS Word
Category: Computers > Software
Asked by: billy_mcskintos-ga
List Price: $10.00
Posted: 06 Oct 2006 15:01 PDT
Expires: 05 Nov 2006 14:01 PST
Question ID: 771401
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

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?

There is no answer at this time.

Subject: Re: format merge field in MS Word
From: barneca-ga on 06 Oct 2006 17:40 PDT
since the list of names is already in excel, why not do the truncating
and concatenating in excel, then transfer to word?


Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy