Forum Discussion

Ross Fesenmeyer's avatar
Ross Fesenmeyer
Copper Contributor
May 02, 2018

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 Amairah's avatar
    Haytham Amairah
    Silver 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

Resources