i have 3 row

A B
xtrm hyper xtrm hyp
hyper xtrm asdfd k

how can i get for the formula of this? if A1 contains the data of b
c1=o
els
C1=

and you may specify the starting lette
for ex. on B1 1st 3 char only that contain in A
1st 3 char of b1 is xtr hy

outpu

A B
xtrm hyper xtrm hype o
hyper xtrm asdfd kd


tnx in advanc

--
xtrmhype
-----------------------------------------------------------------------
xtrmhyper's Profile: http://www.excelforum.com/member.php...fo&userid=2385
View this thread: http://www.excelforum.com/showthread.php?threadid=55944