![]() Conversion of formula results into values.Splitting data to multiple fixed width fields.Splitting data into multiple delimited fields (separated by commas, tabs, spaces, etc.).Conversion of dates which don't match the locale's format (DD/MM/YYYY to MM/DD/YYYY or vice versa).Elimination of the initial apostrophe which prevents values from being recognized as numbers/dates/times. ![]() Conversion of numbers/dates/times to text.Conversion of text to numbers/dates/times (needed if you're receiving #VALUE! errors).Text to Columns is a Calc dialog introduced in version 2.4.1 which allows you to perform many types of data transformations:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |