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
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