How to split multiple items from a single cell

patrick.glenn

Hello,

I have a sheet that allows for a user to input part numbers into a cell seperated by a column. There's no standaridzation to how many parts can/will be entered on each line. I'm trying to seperate this information out onto a new sheet that will contain a unique identifier from the first sheet to allow for users to update status information regarding specific part. I've tried to utilize the Left,Mid,Substitute formulas to seperate these out based on the common deliminator or ",". However, I'm having a hard time figured out how to do this given the various number of parts per cell.

Thanks!

Hudson_Miller

@patrick.glenn

Check out this prior post by @Paul Newcome

https://community.smartsheet.com/discussion/106300/extract-function-select-data-between-defined-tags

Basically - What you have to do is put a special character at the beginning and end of the cell's contents, and use that same character to replace the comma's. Then use mid, Find, and math to pull out the text you want into its own column, one word and one column at a time. Not knowing how many parts will be listed will make this tricky. If you have a known number of possible parts, it may be easier to have a column for each part and use a contains function to search the field to see if that part number exists and simply check a box that the part is in the assembly.