# If formula by counting characters to get result

#### cgreen

##### Active Member
I don't know how to write this argument in a formula ... hope you can help.

Examples of Data from column B:
B2 = (LMP) AMC-AMCC-PMG-C
B3 = (LMP) AMC-AMCC-AF
B4 = (LMP) AMC-AMCC-CPR-B
B6 = (LMP) AMC-AMSAM-CC-MP-A-AB

Formula to start in M2:
If the first 14 characters in B2 equals “(LMP) AMC-AMCC” then return with the first 17 characters of B2 (example of answer: “(LMP) AMC-AMCC-PM”);

If the first 14 characters DO NOT equal “(LMP) AMC-AMCC” then return with the contents of column B (example of answer: “(LMP) AMC-AMSAM-CC-MP-A-AB”).

### Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

#### Charlie45

##### Board Regular
Try =IF(LEFT(B2,14)="(LMP) AMC-AMCC",LEFT(B2,17),B2)

#### cgreen

##### Active Member
Wonderful ... thank you!!!

Replies
5
Views
2K
Replies
2
Views
211
Replies
7
Views
308
Replies
4
Views
316
Replies
3
Views
284

1,190,913
Messages
5,983,531
Members
439,848
Latest member
timmyo

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