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 |
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 |