Thread
: [Solved]
Formula for calculating total when number and letter in one cell
View Single Post
02-20-2017, 11:19 PM
xor
Windows 10
Office 2016
Expert
Join Date: Oct 2015
Posts: 1,097
If you have for example 3Q in B2 try the following formula:
=LOOKUP(9^9,--LEFT(B2,ROW($1:$100)))
xor
View Public Profile
Find all posts by xor