Formula to Switch places

[sakrams]

Good Afternoon Excel Gurus,

Need help from the gurus with a quick formula to achieve the following result. I have a lot of sheets to fix and all sheets have 1000's of rows.

Column A has tags starting with numbers and some starting with characters. I am trying to write a formula that can convert the tags starting with characters to switch as shown in the table below. If the tag is starting with numbers remain with no change in a new column. Is there a quick way of achieving that?

[TABLE="width: 276"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0002654-STL[/TD]
[TD]0002654-STL[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]000322-ST[/TD]
[TD]000322-ST[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]0005-STM[/TD]
[TD]0005-STM[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]0012-STM[/TD]
[TD]0012-STM[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]0016-STM[/TD]
[TD]0016-STM[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]0019-STM[/TD]
[TD]0019-STM[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]0020-STL[/TD]
[TD]0020-STL[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]0020-STM[/TD]
[TD]0020-STM[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]0021-STL[/TD]
[TD]0021-STL[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]0021-STM[/TD]
[TD]0021-STM[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]0050-STL[/TD]
[TD]0050-STL[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]0075-STM[/TD]
[TD]0075-STM[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]0076-STM[/TD]
[TD]0076-STM[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]0078-STL[/TD]
[TD]0078-STL[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]STL-0001[/TD]
[TD]0001-STL[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]STL-0005[/TD]
[TD]0005-STL[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]STL-0010[/TD]
[TD]0010-STL[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]STL-0011[/TD]
[TD]0011-STL[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]STL-0013[/TD]
[TD]0013-STL[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]STL-0014[/TD]
[TD]0014-STL[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]STL-0016[/TD]
[TD]0016-STL[/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD]STL-0017[/TD]
[TD]0017-STL[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]SM-0004[/TD]
[TD]0004-SM[/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD]S-0011[/TD]
[TD]0011-S[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]STM-0013[/TD]
[TD]0013-STM[/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]STM-0015[/TD]
[TD]0015-STM[/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD]STM-0054[/TD]
[TD]0054-STM[/TD]
[/TR]
[TR]
[TD]28[/TD]
[TD]STM-0055[/TD]
[TD]0055-STM[/TD]
[/TR]
[TR]
[TD]29[/TD]
[TD]STM-0057890[/TD]
[TD]0057890-STM[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]STM-005877[/TD]
[TD]005877-STM[/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD]SS-0001[/TD]
[TD]0001-SS[/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD]STS-0004[/TD]
[TD]0004-STS[/TD]
[/TR]
[TR]
[TD]33[/TD]
[TD]STS-0006[/TD]
[TD]0006-STS[/TD]
[/TR]
[TR]
[TD]34[/TD]
[TD]STS-0007[/TD]
[TD]0007-STS[/TD]
[/TR]
[TR]
[TD]35[/TD]
[TD]STS-0008[/TD]
[TD]0008-STS[/TD]
[/TR]
</tbody>[/TABLE]

https://i.postimg.cc/prD4w5dv/SS.jpg

Thanks a million in advance.

 

[footoo]

Re: Help with a Formula to Switch places

https://www.extendoffice.com/documents/excel/4244-excel-swap-data-around-one-cell.html

 

[Phuoc]

Re: Help with a Formula to Switch places

Try this:

=IF(ISNUMBER(LEFT(A1)+0),A1,MID(A1&"-"&A1,FIND("-",A1)+1,LEN(A1)))

 

[sakrams]

Re: Help with a Formula to Switch places

Thanks for your help Phuoc, but this only returns "True"

Try this:

=IF(ISNUMBER(LEFT(A1)+0),A1,MID(A1&"-"&A1,FIND("-",A1)+1,LEN(A1)))

 

[sakrams]

Re: Help with a Formula to Switch places

Thanks for the link footoo.

Is it possible to have a condition if the cell starts with text then ignore the formula (copy the same values) else execute the formula?

https://www.extendoffice.com/documents/excel/4244-excel-swap-data-around-one-cell.html

 

[footoo]

Re: Help with a Formula to Switch places

=if(iserr(left(a2,1)*1),right(a2,len(a2)-find("-",a2)) & "-" & left(a2,find("-",a2)-1),a2)

https://www.extendoffice.com/documents/excel/4073-excel-check-if-first-character-number.html

(Don't see why Phuoc's formula shouldn't work)

 

[sakrams]

Re: Help with a Formula to Switch places

This works Magic... Thanks a million for all your help.

=if(iserr(left(a2,1)*1),right(a2,len(a2)-find("-",a2)) & "-" & left(a2,find("-",a2)-1),a2)

https://www.extendoffice.com/documents/excel/4073-excel-check-if-first-character-number.html

(Don't see why Phuoc's formula shouldn't work)