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