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