On 29 Mar 2007 03:53:16 -0700, wrote:

Hi,

I have an excel spreadsheet where I have a lot of values in coloumn A.
I want to split this into A and B. ( like a snake )

Coloumn A have: 1000, 1001, 1002, 1003 etc
I want to have A: 1000, B: 1001, A: 1002, B: 1003 etc

Is there an easy way to do this?

Assuming your values are all integers, and separated by a ", "
(<comma<space), and that the strings are less than 256 characters long, the
following should work:

Download and install Longre's free (and easily distributable) morefunc.xll
add-in from http://xcell05.free.fr

Then use the following formula:

=REGEX.MID($A$1,"[^, ]+",(ROWS($1:1)-1)*2+COLUMNS($A:A))


Copy/drag across one column.
Copy/drag down as far as required.
--ron