If text is entered directly through the concatenate

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ng the values of the references. While this “little” inventory table may be quicker to build in pure text, how about a car manufacturer or aircraft builder’s inventory? Hint: Once the text string is built and looks good – good data management requires that they be inspected for validity – you can use the Edit > Copy then Edit > Paste Special > Values to eliminate the formulas and stop the transition any time something changes. If text is entered directly through the “Concatenate” formula it must be included in double quotation marks – “ ” as the dashes and spaces were. If embedded formulas and functions are utilized such as the “Vlookup” function, do not precede it with an equal sign (=), Excel will present you with an error message. The comma is used to separate portions of the “Concatenate” formula. While “Concatenate” is limited to seven levels of parenthesis it will operate with “Look To” bringing the results of other formulas and cells into one string. That is, you can use “Concatenate” to assemble text strings generated by other “Concatenate” formulas as shown in cells H44 through H52 where “Concatenate” assembles the part number, the alpha number, the description, and the cost into one string of text. The “Fixed” function is utilized to insure that the presentation of the values remains constant – with commas and two decimal places. Text To Columns The “Text To Columns” function is found through the path Data > Text to Columns from the menu bar. Through this tool you can “unassembled” text strings such as those that were built by “Concatenate” in Page 84 Solving Accounting Principles Problems Using Excel for Windows the “Concatenate” workbook. Open the “Text To Columns” workbook on the data disk. Much of the data is copied from the “Concatenate” workbook to demonstrate how “Text to column” works. Column A contains a copy of the data in column B. This will allow you work w...
View Full Document

This note was uploaded on 09/19/2010 for the course ACCT 220 taught by Professor Ullmann during the Fall '10 term at University of Nebraska Kearney.

Ask a homework question - tutors are online