Here is an example of a single cell from an excel file: Avatyre Freeze 175/65/14 82Q . I need a formula to swap words to make it happen: 175/65/14 82Q Avatyre Freeze , it’s a formula, since I’m far from a programmer and I don’t own macros (
preferably with explanations) thanks in advance)

  • Words of different or fixed length? give an example of several values. - Andrey
  • If you are given an exhaustive answer, mark it as correct (a daw opposite the selected answer). - Nicolas Chabanovsky ♦

1 answer 1

Separation by first numeric character:

 =ПСТР(A1;МИН(ПОИСК({1;2;3;4;5;6;7;8;9;0};A1&1234567890))+1;50)&" "&ЛЕВБ(A1;МИН(ПОИСК({1;2;3;4;5;6;7;8;9;0};A1&1234567890))-1)

Separation by first space:

 =ПСТР(A1&" "&A1;ПОИСК(" ";A1)+1;ДЛСТР(A1))

Search "/" with a 3-digit first number:

 =ПСТР(A1;ПОИСК("/";A1)-3;50)&" "&ЛЕВБ(A1;ПОИСК("/";A1)-4)

50 in formulas - a number not less than the length of the second part of the text.

With a fixed fragment length:

 =ПРАВБ(A1;13)&" "&ЛЕВБ(A1;15)

There may be many options, depending on the data.