I often question my own ability to verbally explain these types of things.
The numbers that I'm trying to break out are hyphenated as in 1 - 4 , or 1
through 4 which equals 1, 2, 3 & 4. In my case there is also Alpha
character attached to each number as in R1-R4. I need to transpose this
so each Alpha/numeric sequence is in it's own cell and put into a column
I hope this is clearer.
<[log in to unmask] To: [log in to unmask]
Sent by: A list to Subject: Re: Split numbers into separate cells
about the technical
aspects of the
03/21/01 02:33 AM
Please respond to A
list to stimulate
discussion about the
technical aspects of
I don't actually follow what you're trying to do here. Could you explain
----- Original Message -----
From: <[log in to unmask]>
To: <[log in to unmask]>
Sent: Tuesday, March 20, 2001 8:15 PM
Subject: Split numbers into separate cells
> What might be the best way to approach the following?
> I have numbers that are R1-R4 for example that represent R1, R2, R3, R4.
> need to write some code that recognizes the range and creates each number
> in it's own cell, preferable vertically.
> R1-R4 would look like the following without the dash and spaces etc.
> Can anyone help me down a suitable path?
> Much thanks !
> Tom Sankstone
> [log in to unmask]