L
LSB
Hi, would like to find out how can i write a macro to
convert a list of text in column.
For example:
3A 0.320 0.320 0.310 0.315 -0.005
A&M 0.900 0.880 0.880 0.880 -0.020
A&M-WA 0.420 N/A N/A N/A N/A
I copy this data into excel sheet in column A, and by
running the macro I want to convert the data into
individual column.
A B C D E F
----------------------------------------------------
3A 0.320 0.320 0.310 0.315 -0.005
A&M 0.900 0.880 0.880 0.880 -0.020
A&M-WA 0.420 N/A N/A N/A N/A
Thanks in advance.
convert a list of text in column.
For example:
3A 0.320 0.320 0.310 0.315 -0.005
A&M 0.900 0.880 0.880 0.880 -0.020
A&M-WA 0.420 N/A N/A N/A N/A
I copy this data into excel sheet in column A, and by
running the macro I want to convert the data into
individual column.
A B C D E F
----------------------------------------------------
3A 0.320 0.320 0.310 0.315 -0.005
A&M 0.900 0.880 0.880 0.880 -0.020
A&M-WA 0.420 N/A N/A N/A N/A
Thanks in advance.