Use this formula in A17 then copy down:
![]()
=SUBSTITUTE(LEFT(A3,FIND(" x",A3)-1),"""","")
Use this formula in A17 then copy down:
![]()
=SUBSTITUTE(LEFT(A3,FIND(" x",A3)-1),"""","")
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks