Dear all , data shift from right side to left side. Below is the example data , need output as CELL B1 form CELL A1
![]()
CELL A1 CELL B1 ETM2-0 0ETM2 ETM2-36 36ETM2 ETM2-597 597ETM2
Dear all , data shift from right side to left side. Below is the example data , need output as CELL B1 form CELL A1
![]()
CELL A1 CELL B1 ETM2-0 0ETM2 ETM2-36 36ETM2 ETM2-597 597ETM2
Last edited by nur2544; 10-03-2014 at 11:31 AM.
Text to columns work?
Hi AlKey, It's perfect ! it will help me a lots.. Thanks for your supports..
i am unable to "add Reputation" as it shows below text notification:
You must spread some Reputation around before giving it to AlKey again.
Last edited by nur2544; 10-03-2014 at 11:39 AM.
Try this
=TRIM(RIGHT(SUBSTITUTE(A1,"-",REPT(" ",25)),25))&TRIM(LEFT(SUBSTITUTE(A1,"-",REPT(" ",25)),25))
A B 1ETM2-0 0ETM2 2ETM2-36 36ETM2 3ETM2-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
Hi NumbersGeek, it is not "Text to columns " issue . Please check CELL B1.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks