I'm looking for a formula (complex, I think) that will do the following.
There are in 9 separate rows (cells) in Col A.(see entries below) I need to extract 2p-7p only into a cell in Col B. If Col A is blank,(row 5) then Col B should be as well.
x 2p-7p Op Canyon 1+4
x2 2p-7p
x2 2p-7p xfact
2p-7p pop Lazy 1+4
2p-7p
2p-7p Up
2p-7p Op Xray
"2p-7p"
Thank you in advance...
Bookmarks