LinkBack URL
About LinkBacks
Try this
=TRIM(RIGHT(SUBSTITUTE(A1,"-",REPT(" ",25)),25))&TRIM(LEFT(SUBSTITUTE(A1,"-",REPT(" ",25)),25))
ETM2-0 0ETM2 ETM2-36 36ETM2 ETM2-597 597ETM2
Try this
=TRIM(RIGHT(SUBSTITUTE(A1,"-",REPT(" ",25)),25))&TRIM(LEFT(SUBSTITUTE(A1,"-",REPT(" ",25)),25))
ETM2-0 0ETM2 ETM2-36 36ETM2 ETM2-597 597ETM2
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks