if a number= string to text

[deanl33069]

so i have a long number from a barcode.
0190027182300349320100024711190409210219892014g
in cells a6-a460
where the 3rd #to the 14th is fixed
90027182300349 and want cell g6-g460 output text tied to that number
so 90027182300349 would = to blue
90027182232456 would=to red
I tried the formula MID(a6,3,14)=
but cant get it to work

 

[DanteAmor]

The formula works to extract those characters, but what I do not understand is what you mean by

so 90027182300349 would = to blue
90027182232456 would=to red

 

[deanl33069]

1st tyvm
so the string is 48-55 numbers long
0190027182300349320100024711190409210219892014g
the 3rd-14 number id the item (aways the same#in (RED)) so all (01)90027182300349320100024711190409210219892014g are the same screwdriver.
(01)90027188888889320176624711190409210219892014g are the same hammer
I want extract the red numbers to a different cell and have it as a text item.
ie 90027182300349 would read screwdriver in the cell with the formula .

hope this makes more sense....
Dean

 

[DanteAmor]

I'm sorry, I still do not understand.
What result do you expect in another cell?

If you have this in cell A2, what do you need in cell B2?
0190027182300349320100024711190409210219892014g


If you have this in cell A3, what do you need in cell B3?
0190027188888889320176624711190409210219892014g

 

[deanl33069]

i want to extract only the red numbers and have them show up in a cell as a text word.
so if i extract 90027182300349 to a cell say G5 to would be a word "hammer"
so all my barcode that have that string will be hammer.

 

[deanl33069]

EXTRACT part of a long number to a text answer

[TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl63, width: 64"]i have this number
01900123456789012345678901234567890[/TD]
[/TR]
</tbody>[/TABLE]
and i am using this statment =mid(a5,3,14)
gives me 90012345678901 i want the result to be HAMMER
ty

 

[Joe4]

Re: EXTRACT part of a long number to a text answer

I am not sure I understand.
How do you extract the word "HAMMER" from a number?

Or, do you mean if you extract that particular 14 digit number, you want to return "HAMMER" to the cell?
If so, try:

[COLOR=#333333]=if(mid(a5,3,14)="[/COLOR][COLOR=#333333]90012345678901","HAMMER","")[/COLOR]

 

[Fluff]

Re: EXTRACT part of a long number to a text answer

@deanl33069
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. (rule 12 here: Forum Rules).

I have merged both threads.

 

[deanl33069]

Re: EXTRACT part of a long number to a text answer

sorry ,
i got this email .but not path
https://www.mrexcel.com/forum/excel...ct-part-long-number-text-answer-new-post.html

 

[Joe4]

Re: EXTRACT part of a long number to a text answer

i got this email .but not path
https://www.mrexcel.com/forum/excel-...-new-post.html

That was because I replied to your new thread, but Fluff rightly merged it into your original question.
So, the automated email reply is referencing the "new" thread, which no longer exists. The question and reply have been moved here.
As he said, please do not post the same question in multiple threads.