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

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