Replace parts of a cell (Numbers and letters)

[nicdyb]

Hi, I need to extract 2 specific different "IDs" from each cell into 2 different cells.

Example:

95-02-87 D (GD-08-1347)

I managed to extract the "95-02-87 D" by using: Find: (*) Replace with: blank

How do I extract the numbers? So the only thing im left with is "GD-08-1347"?

Preferably the "(" and ")" shouldn't be there aswell.

Thanks alot guys I can do it manually, but its over 1000 cells =/

[Fotis1991]

Hi and welcome to the forum.

One way could be this.

=RIGHT(A1,LEN(A1)-FIND("*",SUBSTITUTE(A1," ","*",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))

[RobertMika]

If the pattern is the same:
=SUBSTITUTE(RIGHT(A1,FIND("(",A1)-1),")","")

95-02-87 D (GD-08-1347) GD-08-1347
95-02-87 E (G6-08-1347) G6-08-1347
49-02-87 B (bb-08-1347) bb-08-1347

[jraj1106]

Hi

You can try this too..

=TRIM(SUBSTITUTE(MID(A1,FIND("(",A1)+1,LEN(A1)),")",""))

[Marcol]

The first part

Please Login or Register  to view this content.

The second ...

Please Login or Register  to view this content.

This will allow for characters after the ")", e.g. trailing spaces or non-printing characters such as CHAR(160), etc.

[nicdyb]

Thanks for all the help!

But im sorry if this sounds stupid, where exactly am I supposed to fill in the different formulas you guys gave me?

So far I have used the function "Find % Select" in excel.

PS: I am using excel 2007, thought it was 2010.

And I see some type A2 here, and some A1, this is a cell I can copy and drag down right? So the A jumps to A2, A3 etc when I move 1 cell down?

[RobertMika]

If youd ata are in Column A put the formmula(s) in B1(and C1) and copy/drag down.
You should get result you required

[nicdyb]

Thats the thing. When I paste the formulas, I get an error saying: The formula you typed contains an error

When I press enter, it leads me to the phrase "find" in the formula

[Marcol]

It might be your regional delimiter.
Change the comma seperators to semicolons.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[nicdyb]

Thanks ALOT! Worked like a charm :D