extracting text data in a cell
 

hi.. how can i extract data from a cell.. for example..

the text in cell A1.
"This is an apple"

by using the formala: =LEFT(A1,4)
i'm only able to extract the word "This"

but is there any method where i can extract the words "This" & "an" ??
thanks..

gareth1983, here is one way,

=LEFT(A1,4) & MID(A1,9,2)
or with a space between them
=LEFT(A1,4) &" " & MID(A1,9,2)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"gareth1983" wrote in message
...

hi.. how can i extract data from a cell.. for example..

the text in cell A1.
"This is an apple"

by using the formala: =LEFT(A1,4)
i'm only able to extract the word "This"

but is there any method where i can extract the words "This" & "an" ??
thanks..


--
gareth1983

Thank you. I've found that very useful..
Regards.