Extract code from text string

**dionysusftw** · 01-30-2014, 11:55 AM

CODES.xlsxI need help extracting from a cell, a code that is formed from letters and numbers. For example:

SOFT CASE SAMSUNG EXTRASLIM SMGR4F FOR SAMSUNG GALAXY S4
I need a formula to extract "SMGR4F"

HARD BACK CASE SVDBCASE0043 IPHONE4/4S FOR IPHONE 3
I need extracted "SVDBCASE0043"

NOTE: It is always the first word that contains text+number
I attached a document with a part of the codes, and bebo021999's formula, which works for most of the codes.

I really hope you can help me with this,
Thank you and best regards!

**bebo021999** · 01-30-2014, 01:02 PM

Assuming A1 is code, try this array formula:

Please Login or Register  to view this content.

Confirmed with Ctrl-shift-enter

**dionysusftw** · 01-30-2014, 02:22 PM

You are extraordinary, sir!! The formula works, but it always leave out the last digit/letter of the code. Could you please fix that?

Best Regards!

Originally Posted by bebo021999

Assuming A1 is code, try this array formula:

Please Login or Register  to view this content.

Confirmed with Ctrl-shift-enter

**bebo021999** · 01-30-2014, 02:30 PM

I am confusing with my formula myself a little bit! It is too complicated to remind

Can you try to delete "-1" at the end of it?

Extract code from text string

LinkBack

Thread Tools

Rate This Thread

Display

Extract code from text string

Re: Extract code from text string

Re: Extract code from text string

Re: Extract code from text string

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Find and extract text string from within another text string

Code to Extract certain text from a string

[SOLVED] How to Extract A Number from String if Text within the String Equals XYZ

[SOLVED] extract text string when you only know the last three letters of that string

Extract small string of text from larger string

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions