Forum Discussion
Fill cell with given data
I need an excell spreadsheet that can fill information based on given information. For example column A in each cell will have text as below sales order number '' sales order number '' sales o...
Hi Ross,
Supposing that the order numbers are in column B next to order labels, so please use this formula in column C:
=REPLACE(A1,SEARCH("'",A1)+1,0,B1)And find it in the attached file.
I hope this helps you
Regards
thank you very much exactly what i needed
