Macro For Cleansing

[bigdee008@yahoo.com]

The situation is: I have a about 15000 lines of data that needs to be cleansed. I need to change the Item description from e.g
Uncleansed = OFFSET TIB TRAY NEUTRAL ADAPTOR
Cleansed = ADAPTOR OFFSET TIB TRAY NEUTRAL is there a way I can do this automatically? with a macro?
thanks

[tigeravatar]

bigdee008@yahoo.com,

Welcome to the forum!
If all you need is to put the last word as the first word, either of these should work for you:

Formula solution:
=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99))&" "&SUBSTITUTE(A1," "&TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99)),"")


Macro solution:

Please Login or Register  to view this content.