| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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.. |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
Thank you. I've found that very useful..
Regards. Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A cell displays many ###'s instead of the text data. | Excel Discussion (Misc queries) | |||
| Using a Text / Data output as a cell reference | Excel Discussion (Misc queries) | |||
| Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Hybrid Mode
