Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
text to column/row
I have some data i need to separate out. the data looks like this:
partnumber description location 1234 resistor R1, R3, R10 I need to be able to break the location out by comma. but i need to place it in the next row under the first location. i think need to fill the rows under it with the other data. ie: partnumber and description. it should look like this: 1234 resistor R1 1234 resistor R3 1234 resistor R10 Can someone give me a hand with this? I know i can do text to column but it may be 1 column or 100. Even if i can get this i still need to place the value under the previous value. There will also be several lines so i need to "INSERT" a row not just put it in the next row down! thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to subtract one text column based on their text column MS xls. | Excel Discussion (Misc queries) | |||
Find a text from a column in a text string within another column? | New Users to Excel | |||
Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
I want to put the text in the cell of column B in front of the the text in column D. | Excel Programming | |||
Wrap text in column headers to fit text in column | Excel Discussion (Misc queries) |