Extracting Text

[ejsifuen1124]

I try to stay away from asking questions on this forum as much as possible but I would really appreciate help on finding a solution to a problem!

I'm looking to extract the numbers (one, two or three digits) between certain text/characters. Example assuming the cell is A2:

The formulas would go cells C2:E5 in this example, while extracting the number that corresponds with the table header (row 1) with the information in column A.

I hope this makes sense and thanks in advance!

 

[jtakw]

Hi,

Use B2 formula, result is Text, in case you have leading 0 values that you want kept intact (e.g. 012, 005, etc.)
Use G2 formula, result converted to Real numbers, easier for further math/comparisons.

Book3.xlsx
	A	B	C	D	E	F	G	H	I	J
1		C	A	AB	AC
2	C-76,A-2,AB-3,AC-100	76	2	3	100		76	2	3	100
3	AB-1,C-100,AC-2	100		1	2		100		1	2
4	AC-3,C-100	100			3		100			3
5	C-32	32					32
Sheet828

Cell Formulas
Range	Formula
B2:E5	B2	=IFERROR(TRIM(LEFT(SUBSTITUTE(MID(","&$A2,FIND(","&B$1&"-",","&$A2)+2+LEN(B$1),255)&",",",",REPT(" ",99)),99)),"")
G2:J5	G2	=IFERROR(LEFT(SUBSTITUTE(MID(","&$A2,FIND(","&B$1&"-",","&$A2)+2+LEN(B$1),255)&",",",",REPT(" ",99)),99)+0,"")