Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text string divided into 4 columns
Hi,
I have information in one column imported from another system. The information is structured in one text string but each row includes a set of 4 different data strings diveded by a comma ",". Like this: Red,house,door,20000 blue,cat,mouth,500 etc I need a macro that look at all rows and dived the information in to 4 diffrent columns like this; column A B C D Red house door 20000 blue cat mouth 500 Grateful for any help in this issue. Thanks! Mats |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text string divided into 4 columns
Hi,
You dont really need a macro to do this Click Data / Text to columns / delimited / select comma and you're done regards, julian Wes wrote: Hi, I have information in one column imported from another system. The information is structured in one text string but each row includes a set of 4 different data strings diveded by a comma ",". Like this: Red,house,door,20000 blue,cat,mouth,500 etc I need a macro that look at all rows and dived the information in to 4 diffrent columns like this; column A B C D Red house door 20000 blue cat mouth 500 Grateful for any help in this issue. Thanks! Mats |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text string divided into 4 columns
hi wes
you can select the first column and then do following: go to "Data" -- "Text to Column..." -- there you choose: - Delimited - Next - deselect "Tab", select "comma" - next - Finish if you need it automated, just record the macro and have a look at the code, that Excel provides hth Carlo "Wes" wrote: Hi, I have information in one column imported from another system. The information is structured in one text string but each row includes a set of 4 different data strings diveded by a comma ",". Like this: Red,house,door,20000 blue,cat,mouth,500 etc I need a macro that look at all rows and dived the information in to 4 diffrent columns like this; column A B C D Red house door 20000 blue cat mouth 500 Grateful for any help in this issue. Thanks! Mats |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Splitting text divided by carriage returns | Excel Worksheet Functions | |||
If formula true result then divided into 2 columns | Excel Worksheet Functions | |||
Averaging Columns based on a Text String | New Users to Excel | |||
Separate a FirstLast text string into two columns | Excel Discussion (Misc queries) | |||
How can I break down a string with data divided by commas | Excel Programming |