| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
extracting data from one cell to another
I have a sheet that i downloaded from our erp system that has one
column with text. the text is long and descriptive. the only thing is the same is that there is one piece that starts with QN then a blank then 11 numbers like this. QN 40000152489. What i want to do is pull that from the text cell to another cell. Is that possible? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
extracting data from one cell to another
Try
=MID(A2,FIND("QN ",A2),14) and copy down -- HTH Bob "pat67" wrote in message ... I have a sheet that i downloaded from our erp system that has one column with text. the text is long and descriptive. the only thing is the same is that there is one piece that starts with QN then a blank then 11 numbers like this. QN 40000152489. What i want to do is pull that from the text cell to another cell. Is that possible? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
extracting data from one cell to another
=Left(A1,14)
Pulls the first 14 characters from the cell. Jeff "pat67" wrote: I have a sheet that i downloaded from our erp system that has one column with text. the text is long and descriptive. the only thing is the same is that there is one piece that starts with QN then a blank then 11 numbers like this. QN 40000152489. What i want to do is pull that from the text cell to another cell. Is that possible? . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
extracting data from one cell to another
Try the below...This might go wrong if you have multiple instances of the
text "QN " With text in cell A1 =IF(ISNUMBER(FIND("QN ",A1)),MID(A1,FIND("QN ",A1),14),"") -- Jacob (MVP - Excel) "pat67" wrote: I have a sheet that i downloaded from our erp system that has one column with text. the text is long and descriptive. the only thing is the same is that there is one piece that starts with QN then a blank then 11 numbers like this. QN 40000152489. What i want to do is pull that from the text cell to another cell. Is that possible? . |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
extracting data from one cell to another
On Apr 30, 10:54*am, Jacob Skaria
wrote: Try the below...This might go wrong if you have multiple instances of the text "QN " With text in cell A1 =IF(ISNUMBER(FIND("QN ",A1)),MID(A1,FIND("QN ",A1),14),"") -- Jacob (MVP - Excel) "pat67" wrote: I have a sheet that i downloaded from our erp system that has one column with text. the text is long and descriptive. the only thing is the same is that there is one piece that starts with QN then a blank then 11 numbers like this. QN 40000152489. What i want to do is pull that from the text cell to another cell. Is that possible? .- Hide quoted text - - Show quoted text - I do so that won't work |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
extracting data from one cell to another
On Apr 30, 10:46*am, Jeff wrote:
=Left(A1,14) Pulls the first 14 characters from the cell. Jeff "pat67" wrote: I have a sheet that i downloaded from our erp system that has one column with text. the text is long and descriptive. the only thing is the same is that there is one piece that starts with QN then a blank then 11 numbers like this. QN 40000152489. What i want to do is pull that from the text cell to another cell. Is that possible? .- Hide quoted text - - Show quoted text - can't use left, the QN could be anywhere in the text |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
extracting data from one cell to another
On Apr 30, 10:42*am, "Bob Phillips"
wrote: Try =MID(A2,FIND("QN ",A2),14) and copy down -- HTH Bob "pat67" wrote in message ... I have a sheet that i downloaded from our erp system that has one column with text. the text is long and descriptive. the only thing is the same is that there is one piece that starts with QN then a blank then 11 numbers like this. QN 40000152489. What i want to do is pull that from the text cell to another cell. Is that possible?- Hide quoted text - - Show quoted text - I will try this |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
extracting data from one cell to another
On Apr 30, 10:42*am, "Bob Phillips"
wrote: Try =MID(A2,FIND("QN ",A2),14) and copy down -- HTH Bob "pat67" wrote in message ... I have a sheet that i downloaded from our erp system that has one column with text. the text is long and descriptive. the only thing is the same is that there is one piece that starts with QN then a blank then 11 numbers like this. QN 40000152489. What i want to do is pull that from the text cell to another cell. Is that possible?- Hide quoted text - - Show quoted text - this works. almost always. It would all the time but i am dealing with morons. Thanks |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
extracting data from one cell to another
What are the morons doing?
-- HTH Bob "pat67" wrote in message ... On Apr 30, 10:42 am, "Bob Phillips" wrote: Try =MID(A2,FIND("QN ",A2),14) and copy down -- HTH Bob "pat67" wrote in message ... I have a sheet that i downloaded from our erp system that has one column with text. the text is long and descriptive. the only thing is the same is that there is one piece that starts with QN then a blank then 11 numbers like this. QN 40000152489. What i want to do is pull that from the text cell to another cell. Is that possible?- Hide quoted text - - Show quoted text - this works. almost always. It would all the time but i am dealing with morons. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need help extracting some data from a cell | Excel Worksheet Functions | |||
| Extracting data from a cell | Excel Worksheet Functions | |||
| Extracting data from a cell | Excel Discussion (Misc queries) | |||
| Extracting data from a cell - please help | Excel Discussion (Misc queries) | |||
| extracting data from a cell | Excel Worksheet Functions | |||
Linear Mode
