In the meantime does this resemble what you want?
With this formula in B1 and filled down.
Formula:
=SUBSTITUTE(UPPER(A1),UPPER(TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",256)),256,256))),PROPER(TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",256)),256,256))))
If not we'll need a workbook.
|
A |
B |
1 |
MOTOR Ge 6244D |
MOTOR Ge 6244D |
2 |
MOTOR Ge 6244D |
MOTOR Ge 6244D |
3 |
MOTOR KLELEC 5368 1460RPM 5KW |
MOTOR Klelec 5368 1460RPM 5KW |
4 |
MOTOR AGE AK948 1500RPM 10hp |
MOTOR Age AK948 1500RPM 10HP |
5 |
MOTOR KLELEC 4876 1500RPM 12.5hp |
MOTOR Klelec 4876 1500RPM 12.5HP |
Bookmarks