Forum Discussion

yobas's avatar
yobas
Copper Contributor
Jan 15, 2019

Separate text need from not need it

Hi i have below information where have information that i do not need, for sample lines from 1 to 4 and what i need is only description in line 5 (the logic is for each empty cell i am going to need ...
yoba
Wyn Hopkins's avatar
Wyn Hopkins
MVP
Jan 15, 2019
Did you copy the formula down? Are you able to attach the file or if not then a screenshot?
yobas's avatar
yobas
Copper Contributor
Jan 15, 2019

Hello Wyn

 

Sure i did, i have attached the file with formula, it seems to be near of the solution, i think this formula require some adjusments or i am doing something wrong. Because it worked in the first group of data, but in the second not (It was un blank as well). Do you know why in the Second group of date it did not work ?

    • yobas's avatar
      yobas
      Copper Contributor
      Jan 16, 2019

      Hi Wyn

       

      Excellent, thank you very much, it seems to worked, however, when i copy formula and paste as value, and i try to sort (To delete blank espaces)  it change the description to "#¿NOMBRE?" in another cells, even in description field as well, do you know how can. i fix this

      • yobas's avatar
        yobas
        Copper Contributor
        Jan 16, 2019

        I note that the cells empty are not empty, putting a filter i see values like #¡REF¡ and  #¿NOMBRE?, how can i do that the "empty cells" will be really empty

Resources