Make calculation using only the first character in a cell

Rameses

Board Regular
Joined
Mar 3, 2010
Messages
137
Hi all

I have been puzzling over this one below

I want to use only the first character in a cell to make a calculation but have not worked out how to combine the 2 formulas

so

for example 'D+' is in my first cell
but I only want to use 'D' for my calculation (but I dont want to change the D+ in the cell

=LEFT(A1,1) that gives me the 'D"

I now want to incorporate it into the formula

=MATCH(A1,A74:A82,0)

but am not sure how to do this

any comments would be appreciated

many thanks

Rameses :)
 
Last edited:

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Forum statistics

Threads
1,136,336
Messages
5,675,184
Members
419,553
Latest member
hanahass

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top