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
|