Hi Tom
you're right (i forgot that he had 3 digit values). He should change
the formula to
=MID(A1,1+3*(ROW(INDIRECT("1:" & LEN(A1)))-1),3)
To enter this first select sufficient rows (512) and enter this formula
as array formula. As Tom pointed out the OP has to use rows as the
maximum columns are 256.

Frank


Tom Ogilvy wrote:
I think he said 512 values, and showed 3 digit values separated by
commas. With only 256 columns, he would have to at least break the
string in half as a first step to using Data - Text to Columns.




Frank Kabel wrote in message
...
Hi Kevin
I would use 'Data - Text to columns'. Choose fixed lenght though
this
will be quite an effort to choose the delimiting positions for 512
characters :-).
You can also enter the following array formula:
=MID(A1,ROW(INDIRECT("1:" & LEN(A1))),1)
select the target rows, enter this formula and hit CTRL+SHIFT+ENTER
(assumption: A1 stores your string)

HTH
Frank

Kevin G wrote:
Hello,

How would I convert a single cell string consiting of 512 values:
545, 565, 576, etc... to a range of 512 cells.

Thanks, Kevin Graham