Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text to column and selecting values based on a different column
Is there a way to separate a column using Text to column (b with
multiple data in each row) and add content of another column i.e separate b to 52 1222; 52 1442; 52 1477...? A B 52 1222, 1442, 1477, 1722, 1777 52 1232, 1284, 1287, 1311, 1312, 1317, 1322, 1341, Thanks for your assistance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text to column and selecting values based on a different column
Is there a way to separate a column using Text to column (b with multiple data in each row) and add content of another column i.e separate b to 52 1222; 52 1442; 52 1477...? A B 52 1222, 1442, 1477, 1722, 1777 52 1232, 1284, 127, 13, 131243, 13173333, 1322, 1341, becomes C D 521222 521442 Thanks for your assistance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text to column and selecting values based on a different column | Excel Discussion (Misc queries) | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
Conditional coloring of Excel cells, based on adjacent cell values? | Excel Worksheet Functions | |||
selecting values from raw data | Excel Worksheet Functions |