How to shift numeric number from left side to right side of a particular word

**nur2544** · 05-13-2013, 08:23 AM

Dear all, Cell A is my source data , required to convert like Cell B
CELL A CELL B
5ETM2 ETM2-5
12ETM2 ETM2-12
253ETM2 ETM2-253

**benishiryo** · 05-13-2013, 08:31 AM

hi nur2544. assuming 1st alphabet always "E", then:
=MID(A1,SEARCH("e",A1),LEN(A1))&"-"&LEFT(A1,SEARCH("e",A1)-1)

**DonkeyOte** · 05-13-2013, 08:35 AM

If it's always ETM2 as implied by sample:

Formula:

Please Login or Register  to view this content.

If it's not that straightforward let us know.

**rcm** · 05-13-2013, 08:40 AM

try the macro

**nur2544** · 05-13-2013, 09:04 AM

hi benishiryo , thanks it works.

**nur2544** · 05-13-2013, 09:05 AM

hi DonkeyOte, many thanks. it works very well..

Re: How to shift numeric number from left side to right side of a particular word