# Combine two formulas

#### F4TMAN

##### New Member
I'm alittle stuck here trying to figure out how to combine these two formulas

1st Formula is :
Excel Formula:
``=TEXTJOIN("",TRUE,IFERROR(MID(Q17,SEQUENCE(20),1)+0,""))``

2nd Formula :
Excel Formula:
``=MID(A17,14,4)``

Would really appreciate the help thanks

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

#### Saurabhj

##### Active Member
Hi, please confirm on which cells you have written these formulas?

#### Joe4

Combine them how?
What exactly is it that you are trying to do?
It might be best if you walk us through an actual example.

#### F4TMAN

##### New Member
Hi, please confirm on which cells you have written these formulas?
B3 and B4 respectively

#### F4TMAN

##### New Member

My apologies I should've went into more detail. So I have a mix value that looks like this "01-41F23-08". I'm trying to use the MID formula to capture the middle values 41F23. and then extract the F so that the end result is only numeric 4123. Hope that made sense

#### Joe4

Does it always follow the exact same pattern?
Can you give us examples of different variations and the expected result of each?
Otherwise, we may give you an answer that works for this one example, but not the other data you have.
So it is important for us to know the different variations.

#### F4TMAN

##### New Member
Does it always follow the exact same pattern?
Can you give us examples of different variations and the expected result of each?
Otherwise, we may give you an answer that works for this one example, but not the other data you have.
So it is important for us to know the different variations.
yes it always follow the same pattern. So i have a list of them and they start like this
Excel Formula:
``01-41A00-08``
or
Excel Formula:
``01-42B71-08``
. So the pattern doesn't change. The expected result for the first one would be 4100 and for the second would be 4271.

#### Joe4

If that is indeed always the pattern, then a simple formula like this should work (for a value in cell A1):
Excel Formula:
``=MID(A1,4,2) & MID(A1,7,2)``

Replies
3
Views
60
Replies
2
Views
64
Replies
6
Views
251
Replies
4
Views
107
Replies
13
Views
118

1,130,212
Messages
5,640,900
Members
417,177
Latest member
njosh

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