Extract specific part of a text

[devo1234]

Hi,

FXD (Dept.014865)

I would like to just have 014865.

Please note:
- I need a formula for about 15,000 rows
- the only consistency is after the "." hence numbers and )
- I do not want the ) & FXD changes up to 10 letters

Thank you kindly,

 

[nonono]

i hope this will help you out
just add the"=" infront of each formula
am not an expert but i just google out and try to help you out

 

[nonono]

or this might be easier for you to understand o.o

 

[devo1234]

i hope this will help you out
just add the"=" infront of each formula
am not an expert but i just google out and try to help you out

Thanks.

LEFT(L8,LEN(L8)-1) won't work because there is text before "0"
RIGHT(M8,3) won't work either since text "FXD" varies across 15,000 rows ex: FXD1221, FXDAE4 etc

 

[Aladin Akyurek]

Like this for example...

In B2 enter and copy down:

=SUBSTITUTE(REPLACE(A2,1,FIND(".",A2),""),")","")

 

[devo1234]

Like this for example...

In B2 enter and copy down:

=SUBSTITUTE(REPLACE(A2,1,FIND(".",A2),""),")","")

Aladin the legend!! Thank you Sir!!!!!

 

[jtakw]

Hi,

Just another way:

Book1
	A	B
1	FXD (Dept.014865)	014865
Sheet149

Cell Formulas
Range	Formula
B1	=SUBSTITUTE(MID(A1,FIND(".",A1)+1,255),")","")

 

[Aladin Akyurek]

Aladin the legend!! Thank you Sir!!!!!

You are welcome.