Excel has a large number of conversion functions. This text will show the ones used to convert lowercase letters into uppercase, uppercase to lowercase, and capitalize the initial letters of each word in the given cell. We will also mention two features that are used to clean the text, either by removing excessive spaces or unprintable characters that often exist in old applications and end up in the table when retreiving data.
By implementing business software we usually retrieve Master data from the previously used application, primarily the Partners and Items. Data is usually exported from old software to Excel, it is processed, and imported into a new application. When processing, there is often a need to “cut” the text in one of the columns from the left, from the right or from the given position, or to find a part of it in order to use it to generate some new content …
When someone tells you, “I’m left without text” this usually means a state of shock and confusion. Ignoring text related functions will not leave you in shock, but you will certainly be deprived of some useful tools. These functions are numerous, and in the “recipe” that follows I’ll describe these that allow merging of two or more texts into one, converting text to number or number in text, determining the length of text …