answersLogoWhite

0

You could use the CONCATENATE function or the & operator. The following two formulas will do the exact same thing. They both use the MID function to extract two pieces of text and then combine them into one piece of text.

=CONCATENATE( MID( A2, 2, 3 ), MID( A3, 2, 4 ) )

=MID( A2, 2, 3 ) & MID( A3, 2, 4 )

User Avatar

Wiki User

∙ 10y ago

What else can I help you with?

Related Questions

What is in an expression?

In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.


What is an expression in excel?

In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.


How many functions can be nested with the same formula in MS Excel?

Excel 2003 = 8 levels of nesting Excel 2007 = 64 levels of nesting


What are the functions Microsoft Excel?

Functions allow you to perform some mathematical or string procedures to other cells.


What are the functions of cells in Excel?

In effect a cell in Excel is a box where either text, number or formula can be placed.


What Functions may be entered for formulas in Excel?

Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.


Does the CONCATENATE function in Excel require a text argument?

Normally yes, but it will actually take numbers and combine them into a text string.


What is user generated formula in Excel?

It is a formula that the user creates themselves, instead of using the built-in functions.


Which function of Excel does not work with 3D formulas?

There are several functions of Excel that do not work with 3D formulas. These include cell references and range formula.


What are the types of formula in Microsoft Excel?

You could not really classify formulas into types as the amount of formulas are infinite and you can have a variety of things happening in a formula. Functions come in categories, and that is maybe what you mean. It will depend on which version of Excel you have, but these are the categories available in later versions: Cube functions Database functions Date and time functions Engineering functions Financial functions Information functions Logical functions Lookup and reference functions Math and trigonometry functions Statistical functions Text functions


Does functions inserted from the Insert Functions button and from the SUM list require the Excel user to type the equals sign for each formula?

yes


Can a formula contains several functions Excel starts with the outermost function and then moves inward?

The innermost functions will be calculated first as their results form the arguments for the outer functions.

Trending Questions
What is The correct order in which you should install components into the case after disassembling the computer? What are the Five similarities between a computer keyboard and a electronic typewriter keyboard? A vertical section of track that passes through all platters on a hard disk? What versions of Windows support HyperThreading? What companies develop reliable free partition recovery software? Where can Microsoft Office Student Edition be purchased online? What is the bad effect of computer? How many letter gas in one gallon gas? How can you properly shutdown Windows 98SE when you get a sign saying Windows is shutting down that hangs there until you manually push the off switch? In PowerPoint the best way to get a slide show to stop is to? What file system is used by DOS? How many cubic feet is 5'6? Which General Staff position prepares and documents the Incident Action Plan and collects and evaluates information maintain resource status and maintains documentation for incident records? What is the primary purpose of Lean Six Sigma? When printing a document and the width is greater than the height what is this called? What is the difference of absolute age and relative age? How do you fully restore a Toshiba Satellite A105 without recovery disks? At its time of construction one of the fastest computers in the world is referred to as a(n) . and 8203 Select one? What is mask in Photoshop? What type of text is to be printed at the top of each page in a document?