Forum Discussion
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 ...
or this one (which references blanks on the next row)
Thank you, but in second group did not work
| COL1 | Formula | |
| 1 | Servicios de importacion en USD - Servic | |
| 2 | Servicios d | |
| 3 | Servicios de importacion | |
| 4 | Servicios de importacion e | |
| 5 | Servicios de importacion | Servicios de importacion |
| 1 | Servicio especializado de soporte tecnic | |
| 2 | Servicio especializado de soporte tecnico | |
| 3 | Servicio especializado de soporte tecnico | |
| 4 | Servicio especializado de soporte tecnico | |
| 5 | Servicio especializado de soporte tecnico | |
| 6 | Servicio especializado de soporte tecnico | |
| 7 | Servicio especializado de soporte tecnico | |
| 8 | Servicio especializado de soporte tecnico | |
| 9 | Servicio especializado de soporte tecnico | |
| 10 | Servicio especializado de soporte tecnico | |
| 11 | Servicio especializado de soporte tecnico | |
| 12 | Servicio especializado de soporte tecnico | |
| 13 | Servicio especializado de soporte tecnico | |
| 14 | Servicio especializado de soporte tecnico | |
| 15 | Servicio especializado de soporte tecnico | |
| 16 | Servicio especializado de soporte tecnico | |
| 17 | Servicio especializado de soporte tecnico | DOES NOT WORK HERE |
- Did you copy the formula down? Are you able to attach the file or if not then a screenshot?
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 ?
Hi yobas
The cell wasn't actually blank, there was a space there
So I've updated the formula to handle spaces too