Excel Build your own Bundle with Zenva

English Language Only

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