Forum Discussion
Separate in 2 cell
Cell A2: RED LABEL TEA CARTO N 250G 90% 82.57 80.89 9.0% 11.3% After use formula when above line 90% Cell B2: RED LABEL TEA CARTO N 250G Enter below formula in cell B2: =IF(ISNUMBER(FIND(...
Hi amol,
Current logic is:
- find first "%" in the string;
- put in one cell the part of the string to the left from first space before "%";
- put in another cell the part of the string to the right of such space.
Your modified logic in unclear. Would you like to separate on first number without any letters? For example
RED LABEL TEA RS.5/- 14G PK24 120 91.00 89.82 31.9% 33.6%
shall be split on
RED LABEL TEA RS.5/- 14G PK24 120 91.00 89.82 31.9% 33.6%
or what?
In any case, I guess it'll be another set of formulas for another logic.