concatenated data

[dgavilanes]

Hi All,I have a single column with this data -1.2 to 0.7 , I need to create two columns

A=-1.2

B=0.7


Any suggestions, would be greatly appreciated


Dennis

 

[Luke M]

Quickest would be using Data - Text to Columns, with space as a delimiter. This would actually create 3 columns, but you could easily delete the middle column (containing the word "to").

 

[dgavilanes]

Thanks,


Not sure how write it

Sorry


Dennis

 

[dgavilanes]

I've got it!!!