Return characters after first number in a cell

Hi everyone,

After a significant amount of searching, I'm still trying to figure out how to return all of the characters in a cell that appear to the right of the first number. Here are two examples of typical cells:

Grammas v. Lockwood Associates, LLC, 944 N.Y.S.2d 623 (App. Div. 2nd Dept. 2012).

AT&T Advertising, L.P. v. Winningham, 280 P.3d 360 (Okla. App. 2012)

Essentially, I want to split the case name from the citation, so if I can extract everything after the first number, I'm in good shape.

Thanks!

Hey guys,

Thanks for your help and sorry for not being more specific. Here is the example again and the result I'm seeking.

Example:

Grammas v. Lockwood Associates, LLC, 944 N.Y.S.2d 623 (App. Div. 2nd Dept. 2012).

Result:

944 N.Y.S.2d 623 (App. Div. 2nd Dept. 2012).

Benishiryo, I used your formula and made a small change to get the right result.

=MID(C3,MIN(FIND({0,1,2,3,4,5,6,7,8,9},C3&"0123456789")),LEN(C3))

With all that said, if I wanted to extract everything BEFORE the first number, how would I change that formula?

Thanks again in advance.

You guys are good. Thanks for your help. Will save me a LOT of time.

Hey, sorry to trouble you again, Tony, but am trying to figure out an efficient way to remove a parenthetical from cells.

Here's what I have in thousands of rows:

Lee v. Brown, No. 3:08-CV-01206 CSH, 2009 WL 3157542 (D. Conn. Sept. 25, 2009) (stating that rule that partnership has citizenship of each of its partners for purposes of diversity jurisdiction applies to LLPs).

In the above, I want to remove the second parenthetical so I end up with this:

Lee v. Brown, No. 3:08-CV-01206 CSH, 2009 WL 3157542 (D. Conn. Sept. 25, 2009)

Is there a formula that would identify the second "(", delete it and everything after it? Or would it work to insert a symbol such as a "@" after the first ")" and then run a second formula that removes everything after the "@"?

Thanks in advance.

Is there a way to replace only the second "(" that appears in the string with a "*"?

You're absolutely right, SHG. Apologies, I misunderstood at first. Thanks for your help.