Thread: 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

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

=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" <sujit_shukla.2cmofe_1155723606.9562@excelforum-nospam.com>
wrote in message
news:sujit_shukla.2cmofe_1155723606.9562@excelforum-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
>