Mid Function
 

This is the first column
Column A
Abdul Narayan D'souza
Sujit Satyadhar Shukla
wasim Khan

so the second column shud have formula which wud give result
Column B
A N D'souza
S S Shukla
W Khan

how is this possible


--
sujit_shukla
------------------------------------------------------------------------
sujit_shukla's Profile: http://www.excelforum.com/member.php...o&userid=37587
View this thread: http://www.excelforum.com/showthread...hreadid=572130

Mid Function
 

This is the formula I figured out to work for what you are asking

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

"sujit_shukla" wrote:


This is the first column
Column A
Abdul Narayan D'souza
Sujit Satyadhar Shukla
wasim Khan

so the second column shud have formula which wud give result
Column B
A N D'souza
S S Shukla
W Khan

how is this possible


--
sujit_shukla
------------------------------------------------------------------------
sujit_shukla's Profile: http://www.excelforum.com/member.php...o&userid=37587
View this thread: http://www.excelforum.com/showthread...hreadid=572130

Mid Function
 

=IF(LEN(A1)-LEN(SUBSTITUTE(A1," ",""))=1,LEFT(A1,1)&MID(A1,FIND("
",A1),99),LEFT(A1,1)&MID(A1,FIND(" ",A1),2)&MID(A1,FIND(" ",A1,FIND("
",A1)+1),99))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"sujit_shukla"
wrote in message
news:sujit_shukla.2cmofe_1155723606.9562@excelforu m-nospam.com...

This is the first column
Column A
Abdul Narayan D'souza
Sujit Satyadhar Shukla
wasim Khan

so the second column shud have formula which wud give result
Column B
A N D'souza
S S Shukla
W Khan

how is this possible


--
sujit_shukla
------------------------------------------------------------------------
sujit_shukla's Profile:
http://www.excelforum.com/member.php...o&userid=37587
View this thread: http://www.excelforum.com/showthread...hreadid=572130