Would there be a formula for splitting a line like the following into separate cells:
Below is what I want it to look like: (COL indicates column separators, for example only, not to be used)rear handle assy, replaces 20870-65100, 20870-65101, 20870-65102
Instead of:
Should be:(COL1) rear handle assy, replaces, 20870-65100, 20870-65101, 20870-65102
Basically, the formula could define the separating point by splitting "replaces" and everything after that into a new column. PLEASE NOTE that the comma after "assy" has been removed in the finished example...that's how I want it, if possible. I don't want that first comma there after the line has been split.(COL1) rear handle assy (COL2) replaces 20870-65100, 20870-65101, 20870-65102
Thanks in advance, I appreciate any help very much, as I'm an Excel novice.
Bookmarks