Excel in Excel®!. Issue 2 (1st February 2016)

• Record Type: Journal Article
• Authors: Ayer, Ganesh
• Is Part Of: Energy engineering. Volume 113:Issue 2(2016)
• Page Start: 63
• Page End: 74
• Publication Date: 2016-02-01
• Subjects: Power (Mechanics) -- Periodicals; 621.04205
• DOI: 10.1080/01998595.2016.11668653
• Languages: English
• ISSNs: 0199-8595

Abstract

ABSTRACT: In this issue, we explore the use of text functions available in Excel. As an energy professional, you often receive or retrieve data from many sources in a wide variety of formats such as a text or a CSV file. You don't always have control over the data format when you import from an external source. Before you can analyze the imported data, you often need to clean it up, and this is where Excel's text functions help you get the data in the precise format that you need for further analysis.