| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert text to column using macro
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to convert text | Excel Discussion (Misc queries) | |||
| Convert Text to Numbers in a Macro | Excel Worksheet Functions | |||
| Having macro convert text to numbers | Excel Discussion (Misc queries) | |||
| Macro to convert hyperlinks to text | Excel Worksheet Functions | |||
| Macro to convert text to date | Excel Worksheet Functions | |||
Threaded Mode
