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, 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 Use Guidelines & Forum Rules
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