Begin manipulating text data within Microsoft Excel using native functions. Whether you need to combine, split, or analyze various text-based values from different columns, this course will help you to implement text functions that work with both numbers and strings. Through these, you will transform your text-based worksheets and more efficiently manage your addresses, dates, order information, and more.
You will learn how to:
● Merge multiple columns with text content into one column
● Use the TEXTJOIN function for advanced concatenation
● Extract and alter text data from a cell
● Manipulate text from irregular strings with FIND and SEARCH
● Use the SUBSTITUTE function to dynamically replace text
● Convert a string/text value into a number value
About this Promotion
Learn and Excel! Master spreadsheets, data reporting and management, and much more with up to 12 courses available in the Excel Build your own Bundle with Zenva