Thread
:
extracting text data in a cell
View Single Post
#
3
gareth1983
Junior Member
Posts: 2
Thank you. I've found that very useful..
Regards.
Quote:
Originally Posted by
Paul B
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
Reply With Quote
gareth1983
View Public Profile
Send a private message to gareth1983
Find all posts by gareth1983