How do I get the first letter of a word in excel

Shadowofthedarkgod

Posts: n/a

How do I get the first letter of a word in excel

I have this problem, see I want to create a script, I have the following
information available to me.

First name: John
MI: C
Last name: Doe

Now this is what I want; I want to convert this John C. Doe to "jcdoe". Also
I have similar problems to with dual last names, like dela toya, I have to
convert from juan r. dela toya to jrdelatoya. How do I do that? Thanks!!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ???	Richard	Excel Discussion (Misc queries)	2	May 13th 23 11:46 AM
Entering Excel information into MS Word	dwalsh77	Excel Discussion (Misc queries)	0	April 8th 05 05:29 PM
Column format when merging Excel data to Word labels	Red	Excel Discussion (Misc queries)	1	April 6th 05 03:40 AM
Installed Word XP only, then applied Office SP3, then Excel - need 2 re-update?	Maged	Excel Discussion (Misc queries)	0	March 5th 05 10:37 PM
getting specific info from a word document into excel	smintey	Excel Discussion (Misc queries)	3	December 8th 04 08:20 PM

All times are GMT +1. The time now is 06:22 PM.

Menu

About Us