Mid Function

[sujit_shukla]

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

 

[Guest]

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)))

 

[Bob Phillips]

=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" <[email protected]>
wrote in message
news:[email protected]...