# Make calculation using only the first character in a cell

#### Rameses

##### Board Regular
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

many thanks

Rameses

Last edited:

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

#### chicagodiceman

##### Active Member
=MATCH(left(A1,1),A74:A82,0)

Thank you

Works a dream

Replies
4
Views
187
Replies
6
Views
140
Replies
4
Views
180
Replies
12
Views
1K
Replies
9
Views
259

1,171,827
Messages
5,877,775
Members
433,287
Latest member
amna_shahbaz

### 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.

### Which adblocker are you using?

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

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