About this product
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