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

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

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
6
Views
222
Replies
4
Views
79
Replies
11
Views
183
Replies
4
Views
79
Replies
4
Views
126

1,127,832
Messages
5,627,152
Members
416,224
Latest member
RichardHell

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.

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