Fill cell with given data

[Ross Fesenmeyer]

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.

[#2]

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

[#3]

thank you very much exactly what i needed