Combine two formulas

F4TMAN

New Member
Joined
Jun 29, 2020
Messages
23
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Saurabhj

Active Member
Joined
Jun 6, 2020
Messages
423
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Hi, please confirm on which cells you have written these formulas?
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
57,034
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Jun 29, 2020
Messages
23
Office Version
  1. 365
  2. 2010
Platform
  1. Windows

ADVERTISEMENT

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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
57,034
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Jun 29, 2020
Messages
23
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
57,034
Office Version
  1. 365
Platform
  1. Windows
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)
 

Watch MrExcel Video

Forum statistics

Threads
1,130,292
Messages
5,641,379
Members
417,207
Latest member
Vxhaet

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