move number to next column

[wrenlea1]

Hi All
Hopefully a simple question but I have not used excel properly for some while.....
I have a long column of names and dates all in the same format using ( ) around a year. It looks like this:-
John Doe (1976)
Could someone let me know what formula to add to the next column to pull the 4 digit number in brackets into the next column?
Thanks
Peter

 

[Joe4]

Welcome to the Board!

Since you are using Excel 365, you should be able to use these functions:

=TEXTBEFORE(TEXTAFTER(A1,"("),")")

(for a value in cell A1)

 

[mumps]

Try this formula:

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

 

[wrenlea1]

Try this formula:

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

Welcome to the Board!

Since you are using Excel 365, you should be able to use these functions:

=TEXTBEFORE(TEXTAFTER(A1,"("),")")

(for a value in cell A1)

I can and it works Many thanks Peter

 

[wrenlea1]

Try this formula:

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

that works too Many thanks Peter

 

[Scott Huish]

=-TEXTAFTER(A1," ",-1)