How to Convert String to Value in Excel

August 9, 2022
905 Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

Working in Excel/Spreadsheet WPS involves handling data of different kinds. Sometimes the data is in the form of values and sometimes the data is in the form of text or strings. When we have to make calculations we cannot apply formulas on the string data which can make our work hard to complete in time. 

Many people are unaware of How to Convert String to Value in Excel/Spreadsheet (2016/2019/Mac/Online). There are different ways for doing this task. After following the below-mentioned steps, anyone can easily convert string to value in Excel/Spreadsheet WPS (2016/2019/Mac/Online).

Excel/Spreadsheet is an easy-to-use tool that helps its users by providing so many different methods for processing and categorizing data within a few minutes. The following steps will help you understand How to Convert String to Value in Excel/Spreadsheet (2016/2019/Mac/Online). After reading all the steps, you will be able to convert string to value in Excel/Spreadsheet WPS (2016/2019/Mac/Online) easily.

Different Methods to Convert String to Value in Excel/Spreadsheet WPS 

 How to Convert String to Value in Excel/Spreadsheet WPS Using VALUE Function

1.Open the worksheet in Spreadsheets (WPS Office) which contains the string data.

2.Click on the cell in which you want to convert the string to value and type the VALUE function. 3.Select the cell containing string data. Press Enter and your string data will convert into value.

4.Similarly, drag the corner of the cell in which string has been converted to value and all the string data in those cells will retrieve values

How to Convert String to Value in Excel/Spreadsheet WPS Using Mathematical Function

1.Open the worksheet in Spreadsheets (WPS Office) which contains the string data.

2.Click on the cell in which you want to convert the string to value and type the mathematical function as shown in the picture.

3.Press Enter and your string data will convert into value.

Note: Please make sure that the format of the resulting cell is set to General.

How to Convert String to Value in Excel/Spreadsheet WPS Using LEFT/MID/RIGHT Function

1.Open the worksheet in Spreadsheets (WPS Office) which contains the string data.

2.Click on the cell in which you want to convert the string to value and type the VALUE function with RIGHT/MID/LEFT function as applicable.

3.Select the cell containing string data and the position value from right/mid/left

4.Press Enter and your string data will convert into value.

5.Similarly, drag the corner of the cell in which string has been converted to value and all the string data in those cells will retrieve values.

Note: You can use the MID/LEFT function, in the same way, to convert string to value.

This article has covered the methods on How to Convert String to Value in Excel/Spreadsheet WPS(2016/2019/Mac/Online) Using VALUE Function, How to Convert String to Value in Excel/Spreadsheet WPS Using Mathematical Function and How to Convert String to Value in Excel/Spreadsheet WPS Using LEFT/MID/RIGHT Function. You can use these simple steps as explained above and easily convert string to value in your WPS Excel/Spreadsheet (2016/2019/Mac/Online) whenever required.

Hopefully, you have learned How to convert string to value in WPS Excel/Spreadsheet (2016/2019/Mac/Online) by following the above steps.  If you want to know more about Excel features, you can follow WPS Academy to learn. You can also download WPS Office to edit excel spreadsheets, word documents, and PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.