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 order number ''
sales order number ''
sales order number ''
Ok with that said. I have a list of sales order numbers such as 2343, 2323, 23432, 2349, 32432, I need some way of auto inputting the numbers inbetween each '' example below
sales order number '2343'
sales order number '2323'
sales order number '23432'
sales order number '2349'
sales order number '32432'
order of numbers do not matter.
can this be done
any help apperciated.
- Haytham AmairahSilver Contributor
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
- Ross FesenmeyerCopper Contributorthank you very much exactly what i needed