Again, learn to manipulate text quickly and across thousands of rows with these additional formulas. Len() is short for length, and returns the number of characters in a cell. Search() finds the starting character of a string. And, lastly, Trim() scrubs your data for unwanted additional spaces.
Text00:10 The Len() function returns the LENgth of how many characters are in a specified cell. This is commonly used in combination with other Text functions. Check out the video for a couple examples.
00:50 The Search() function quickly finds the first instance of a specified characters. For example, if we wanted to know what character position that the dash "-" was at in a list of "Item# - Item Desc", it would return 7. This is a perfect function to be combined with the Mid() function - as shown in the video... seek to that position and check it out.
06:40 The Trim() function: have you ever received a table of data from you manager, but you have no history with it and it's your job to scrub/clean up the data? The Trim() function is perfect. This function removes any unwanted/unneeded spaces within a cell. Check out the video for an example. The Clean() function is similar. It takes cells with line breaks and combines each line break into one string of text... no more line breaks. If you use Clean(), be sure to wrap it with Trim() to remove additional unwanted/unneeded spaces!
VideoGIF.png "Len() - Find the number of characters in a cell.")
.gif)
.png "Search() - Find the character number of string of text or number you search for.")
.gif)
.png "Trim() - Remove extra spaces from you data.")
.gif)
Text-Outlines-ALL.xlsx