lentilbake
10-18-2013, 06:45 AM
Hi there, I'm trying to pull out the last (right hand) part of some string data and I'm not having much luck.
I have a list of string data in column A like this:
COL A
3-nitrobenzenecarboxylic acid & its preparation 4A, 13A
3-nitrobenzoic acid and its preparation 4A, 13A
Acid chlorides and their preparation 41, 74, 96B
Acid rain, simulation 92
Partition coefficient / constant / function 36B, 100,
Patton and Reeder's indicator 32
1,2,3-indanetrione hydrate 66
Potassium manganate(VII) / propane-1,2,3-triol reaction 37
and I'd like to extract the last part of the strings to separate columns:
COL B
COL C
COL D
COL E
etc
4A
13A
4A
13A
41
74
96B
92
37
45B
46
36B
100
etc
There are sometimes just 1 number (or number letter combo like 96B) on the end and sometimes 4 5 or more.
This is a one off operation from a long list of some 2000 items so any quick and dirt method would do!
Thanks in advance for any help anyone can give me, I'm struggling because all the functions I commonly use work from the left!
(Apologies for the weird formatting above)
I have a list of string data in column A like this:
COL A
3-nitrobenzenecarboxylic acid & its preparation 4A, 13A
3-nitrobenzoic acid and its preparation 4A, 13A
Acid chlorides and their preparation 41, 74, 96B
Acid rain, simulation 92
Partition coefficient / constant / function 36B, 100,
Patton and Reeder's indicator 32
1,2,3-indanetrione hydrate 66
Potassium manganate(VII) / propane-1,2,3-triol reaction 37
and I'd like to extract the last part of the strings to separate columns:
COL B
COL C
COL D
COL E
etc
4A
13A
4A
13A
41
74
96B
92
37
45B
46
36B
100
etc
There are sometimes just 1 number (or number letter combo like 96B) on the end and sometimes 4 5 or more.
This is a one off operation from a long list of some 2000 items so any quick and dirt method would do!
Thanks in advance for any help anyone can give me, I'm struggling because all the functions I commonly use work from the left!
(Apologies for the weird formatting above)