How do I return characters from within brackets?

A

Acastus

I have a spreadsheet where column "A" concatenates an product name with
its product number. The product are within brackets, and,
unfortunately, are of varying lengths. Herewith two examples:

PRODUCT 123[R56011]
PRODUCT 45678[5065]

What I need to do is create a column "B" that only has the SKU number.
This will allow me to use the VLOOKUP function to match data in other
columns based on the unique SKU number with data in another sheet.
Specifically, the column "B" data for the two examples above should
look like:

R56011
5065

I can't program on my own, but is there a command or function that will
allow me to instruct excel to take only the characters between those
brackets and put it in the adjacent cell in column B, regardless of the
number of characters between the brackets?

If anyone has advice, it'd be great!
 
G

Guest

Try something like this:

For a value in A1

B1: =MID(A1,SEARCH("[",A1)+1,SEARCH("]",A1)-SEARCH("[",A1)-1)

Example:
A1: PRODUCT 123[R56011]
B1: returns R56011

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP
 
R

Ron Rosenfeld

I have a spreadsheet where column "A" concatenates an product name with
its product number. The product are within brackets, and,
unfortunately, are of varying lengths. Herewith two examples:

PRODUCT 123[R56011]
PRODUCT 45678[5065]

What I need to do is create a column "B" that only has the SKU number.
This will allow me to use the VLOOKUP function to match data in other
columns based on the unique SKU number with data in another sheet.
Specifically, the column "B" data for the two examples above should
look like:

R56011
5065

I can't program on my own, but is there a command or function that will
allow me to instruct excel to take only the characters between those
brackets and put it in the adjacent cell in column B, regardless of the
number of characters between the brackets?

If anyone has advice, it'd be great!
Click to expand...

If the only brackets are those surrounding the Product Number, then:

=MID(A1,FIND("[",A1)+1,FIND("]",A1)-FIND("[",A1)-1)

should do it.
--ron
 
A

Acastus

Bless you both! Yes, both work fine. Thanks again - it really saved me
a HUGE amount of crap work!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Urgent help needed? How do I limit the number of characters in a 5
How to limit cell to 30 characters or less 2
2 data types (same col/dif times), do: custom? parse? 2col? 1
How do I remove the last 4 characters within a cell 4
How do I get more than 255 characters into a cell? 3
How do I repeat characters within a single cell in Excel? 3
How to do "text to column" in Access? 1
how do i split names in to two columns 2

Top