This is a discussion on How to get rid of commas between part numbers in a cell? within the Excel Questions forums, part of the Question Forums category; I have a worksheet with several fields/cells of which one contains part numbers separated by commas (such as: 8084430-001,8084430-003,8084430-011,8084430-013). These ...
I have a worksheet with several fields/cells of which one contains part numbers separated by commas (such as: 8084430-001,8084430-003,8084430-011,8084430-013). These part numbers are of different lengths and count.
I need to place each part number in a cell by itself so that it can be found by a vlookup from another worksheet. Is there a formula or VBA code that can accomplish this? It would take hours to do this manually.
Hope this helps, good luck.
Excel 2010 (mainly), 2016 (not Office 365), 2013, 2007, 2003 - Windows 10, 7
- Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
- If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
- Read: Forum Rules & Forum Use Guidelines
You can use Data > Text to Columns, the choose comma delimiter.
If you wan the results in a single column you will then have a manual job to take the 3 or 4 columns and move the data around