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.
- Fall '10