![]() To them we added prefix “ num_” and suffix “ _0” to create new names - num_x_0, num_y_0 and num_z_0. We have edited the names of three numerical variables - x, y and z. The next figure shows an example of a more complex adjustments. In this way we created new names “ Cat_1_string” and “ Cat_2_string”. In this case, we have modified two categorical variables ( Cat_1 and Cat_2) by adding “ _string” value as the suffix. The example is shown in the following illustration. In the Variables list, using the check boxes, you select the variables that you want to rename. As Prefix and Suffix you paste the text values. If you click on it, the setting options will be displayed in the Properties Panel - Prefix, Suffix and Variables. If you want to edit names of multiple columns at once, use the Rename At button found in the ribbon toolbar tab Variable.Ĭlicking this button will show the function in the sidebar. In our example, we use a table containing two categorical ( Cat_1 and Cat_2) and three numeric ( x, y and z) variables. The example is shown in the following figure. With these prefix / suffix editations, the Rename_At function can help you. ![]() ![]() If you want to divide cation and anion components visually, you can insert the “ cat_” prefix for cations and “ an_” for the anions, before their names. Imagine them stored in the “long-form”, where individual samples are stored in rows and the values of individual components are written in columns. An example of use can be found at work with tables of chemical analyzes. Presented function ( Rename_At) allows you to make the work more efficient, if you need to edit multiple columns in the same way - add a text string before or after the current column names. How to Rename Several Excel Columns at OnceĬolumn names editing in Excel spreadsheets is a relatively simple task. ![]()
0 Comments
Leave a Reply. |