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