Say for example, if I need to split this text into 3 columns... "5221234/001-INSTALL x 1" or "5329093-011/004-BULK&CASE ASSY x 1" where the first separator is "/" and the second separator is "x".
HTML Code:
Say for example, if I need to split this text into 3 columns... "5221234/001-INSTALL x 1" or "5329093-011/004-BULK&CASE ASSY x 1" where the first separator is "/" and the second separator is "x".
HTML Code:
How about with a formula setup...
Please Login or Register to view this content.
HTH
Regards, Jeff
Enter in B1 and copy across and down
Formula:Please Login or Register to view this content.
v A B C D 1 5221234/001-INSTALL x 1 5221234 001-INSTALL 1 2 5329093-011/004-BULK&CASE ASSY x 1 5329093-011 004-BULK&CASE ASSY 1
Last edited by AlKey; 06-10-2017 at 10:20 AM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks guys, but I need a macro, not formulas, I have the formulas already. I've solved it though and I'll post what I came up with later.
vba
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks