D
Dave
Hello,
We import strings of numbers into a spreadsheet looking like
this:-
12Rev999,nextrev456
124Rev8888,nextrev1234
In practice the numbers can be any length from 1 to 4 numbers and there are
always three groups. I need to extract these numbers which are in Column A to
Column C
nearly forgot to mention the numbers in this format are text and I need them
as numbers.
Hope you can help.
D
We import strings of numbers into a spreadsheet looking like
this:-
12Rev999,nextrev456
124Rev8888,nextrev1234
In practice the numbers can be any length from 1 to 4 numbers and there are
always three groups. I need to extract these numbers which are in Column A to
Column C
nearly forgot to mention the numbers in this format are text and I need them
as numbers.
Hope you can help.
D