CODEWITHSUNDEEP
excel
Vladimir Čeperković
Vladimir Čeperković

Reputation: 1

Excel how to move word in one cell from right to left?

I have far to many cells that I need to change to do it manually , here's an example

John Johnson-22

Need turned into:

22-John Johnson

Is there a way to do it quick and easy ?

Thanks!

Upvotes: 0

Views: 263

Answers (1)

Gary's Student
Gary's Student

Reputation: 96771

With data in A1, in B1 enter:

=MID(A1,FIND("-",A1,1)+1,9999) & "-" & LEFT(A1,FIND("-",A1)-1)

enter image description here

Upvotes: 2

Related Questions