View Single Post
  #1   Report Post  
gareth1983 gareth1983 is offline
Junior Member
 
Posts: 2
Default 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..