| Re: Splitting column data [message #1017 is a reply to message #1013] |
Wed, 29 July 2020 10:50   |
thomas
Messages: 715
Registered: June 2014
|
Senior Member |
|
|
if your references would be in a column called 'Lit' you could use something like the attached macro. The problem is that there is no easily recognizable separator between the journal name and the first number. This could be solved with a new function lastIndexOf() or reverseIndexOf(). Please let me know, if your references are similar enough for the macro to work. Then I would add the needed function for the remaining cut to make.
[Updated on: Wed, 29 July 2020 10:51] Report message to a moderator |
|
|
|
Search
Help
Members
Register
Login
Home
