I have a worksheet with thousands of rows of data, and I need to extract the UPC number from that row into the column labeled UPC, highlighted in yellow, at the end of that row. The UPC number is in the cell next to the cell that says UPC, in some cases there is no UPC number, and the cell will be filled with text for the next item. In that case if there is no number, I would like the value to be blank.
Last edited by MSchibs; 04-19-2024 at 01:12 PM.
Either of these should do the job:
Formula:
Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Here is a dynamic array version also:
Formula:Please Login or Register to view this content.
Slightly better versions here:
single row
Formula:Please Login or Register to view this content.
dynamic array
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks