Extracting Intials from a name in a cell?

Brian

Posts: n/a

Thanks for the prompt response - works great

"Peo Sjoblom" wrote:

If thge name is like firstname space lastname
however with double names and initials and otyer attributes it becomes
complicated, but for your example

=LEFT(TRIM(A1))&MID(TRIM(A1),FIND(" ",TRIM(A1))+1,1)

will do

Regards,

Peo Sjoblom

"Brian" wrote:

Hi all,

Is there an easy way to extract JUST the initials of a name in a cell if the
name format is:

Cell A1 = Bob Smith

need Cell B1 = BS

Thanks

Brian

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
how to create a variable column in cell reference	Sampson	Excel Worksheet Functions	3	February 21st 05 10:13 PM
Extracting names in a cell	bbc1	Excel Discussion (Misc queries)	2	February 13th 05 06:21 AM
Can a Formula in Cell X modify Cell Y?	alMandragor	Excel Discussion (Misc queries)	7	February 10th 05 09:51 PM
inserting data from a row to a cell, when the row number is specified by a formula in a cell	[email protected]	New Users to Excel	2	January 6th 05 07:18 AM
VLookup resulting in a blank cell...	KempensBoerke	Excel Worksheet Functions	1	October 28th 04 09:57 PM

All times are GMT +1. The time now is 02:30 AM.

Menu

About Us