Split multiple cells into columns.

Hello,

I currently have a variable that has 46000 rows and 1 column.

Each cell looks something like this:

'0 0  0 0  0 821  69 34 15 0000'

I would like to have each of these numbers (as separated by either 1 or 2 spaces) to be in different columns.

The output would therefore be 46000 rows and 10 columns.

I am not sure how to do this and any help would be appreciated!

Answer 1

[Walter Roberson]

   temp = regexp(YourCell(:), '\s+', 'split');
   temp = horzcat(temp{:});
   result = str2double(temp);

[Fiona]

Brilliant. Thank you for your help Walter!