How Do You Concatenate Text In Microsoft Excel?
• Example: Concatenate first and last names. The formula for the result in column C appears in column D below. The arguments to CONCATENATE are a series of text strings to be spliced together. • Example: Concatenate a range of Dates. Dates require special formatting with the TEXT function otherwise they appear as large numbers. • Example: A quote requires two quotes. Below are some examples of placing a double quote in the result string. Example: Use CONCATENATE within INDIRECT. The INDIRECT function takes the value it is given as an address to another cell or range. In rows 5 and 6 below, a cell address in R1C1 format (both rows and columns are numbered) is composed in CONCATENATE. In Rows 7 and 8, the more familiar A1 format (columns are given letters) is used. In row 9, the tab name Apr is spliced into the indirect function in a spreadsheet that has one tab for each month.
