[Solved] Partial cell Text find to new creation of new cell

[ke4avb]

I hope I ask it right.

Documentation is vague on this.

I want to create a formula that uses partial text in one row cell to create a new cell in the same row.


Say if line 285 has DISCONTI in it and I want to create a cell info by combining another cell contents with say -NOS at the end of that contents.

In this case 370 + -NOS becomes 370-NOS in the new cell if DISCONTI is in that row. I would do this each row but row will contain different data.
then the next row it would be 371-NOS.

Now these are part number so it vary in each row.

I know I am probably nuts for asking this crazy thing.

[FJCC]

See if the attached file does what you want. The formulas in column E look for the text "DISCONTI" in column C. If the text is found, the formula returns the text of column B with -NOS appended. Otherwise it returns an empty string.

By the way, it would have been much easier to make a file if you had posted an actual Calc document instead of an image.

[ke4avb]

Thank you...Now I convert the price file for the small one man operation business.

Glad I did have go 50K of lines one at a time.