Ultimate Suite for Excel includes a feature that is handy if you need to convert text. You can convert numbers stored as text to number format, replace irrelevant characters and line breaks with the chars you need, and even change accented characters to their non-accented equivalents.
We care about your data. The add-in will back up your worksheet if you select the corresponding option.
Click the Convert icon on the Ablebits Data tab, in the Text group:
You can see the Convert Text pane:
Click the Convert button to get your result.
I need to keep the following values in brackets but have only 2 decimal points... Thanks
Thank you for your comment.
For us to be able to help you better, please email us a small sample workbook with your source data and the expected result to email@example.com. We'll look into your task and see if our software can help. Thank you.
How do I convert numbers into text?
Thank you for your question. Our add-in can help you convert numbers stored as text to numbers. In other words, it'll change the numbers formatted as text to the number format. If this is not exactly what you mean, please specify. Thank you.
In Convert, can Ablebits convert CR or LF or CRLF or all three? Everything I've read seems to imply it's just CR. I need it to do all!
Sorry if this has been asked a million times, but I don't have time to research. Thanks!
I'm sorry, I'm afraid we don't have any tool that could help you with the task.
But you can send us a sample of your source data and the result you'd like to get to firstname.lastname@example.org. Please shorten your tables to 10-20 rows. We'll forward it to our developers to consider as a new feature.
Hello! Tell me the program only in English? Not in Russian?
Thank you for your question, Ryslan.
Our software is available in English only at the moment.
Hello. I love your tools. I use them regularly in my daily work routine in Excel. I'm currently facing a problem here trying to use the Convert Text tool. I have an excel file (exported from a database) that has a column containing numeric data. Excel shows them as text (and allows each cell to be individually converted to number using its small popup menu). Im trying to use your option to convert number stored as text into a proper number format, but it doesn't work. The tools scans my entire column and then says that no cells have been process. Could you please assist. Thanks.
Thank you for contacting us.
Please try to install the latest version of Ultimate Suite and check if the problem persists there: https://www.ablebits.com/files/get.php?addin=xl-suite
If it doesn't help, please send us a sample workbook with your data for further investigation to email@example.com. We'll do our best to help you.
I am working with Wild Apricot generated website with membership db. My issue is that the db fields are generated by individuals in many formats, Telephone numbers are entered as: xxx.xxx.xxxx or xxx-xxx-xxxx, or (xxx) xxx-xxxx etc.
I would like to export the numbers as a .csv file into Excel 19 , Reformat the list to the first example, and import the updates into WA db. (Without retyping hundreds of items)
Do your addins do functions such as that??
Thank you for contacting us.
For us to be able to help you better, please send us a small sample of your .csv file with your source data and the result you expect to get to firstname.lastname@example.org. I kindly ask you to shorten each table to 10-20 rows.
We'll look into your task and see if our software can help.
I copied and pasted large amount of data into spread sheet...
Everything came over as text... I've tried everything to convert to numbers....
Thank you for your comment and for contacting us at email@example.com. We have received your file and will contact you by email shortly.
Convert Numbers Stored as Text to Numbers. This function does not work. I am able to convert numbers stored as text to numbers using the Excel "pop-up box" (triangle with exclamation point then click on convert to numbers) but not able to convert with Ablebits function. After attempting to convert, there is a box with "no cells have been processed".
Thank you for contacting us. I am sorry you are having difficulty with the Convert Text utility. And thank you for reporting the issue, of course, this is not the way Convert Text should behave!
For us to be able to investigate the problem, please send us your Excel book that contains the worksheet with your data that you tried to process with Convert Text. Please shorten your table to 10-20 rows. Also, please let us know the version of Excel you use and the Ultimate Suite (or Text Toolkit) version.
I have sent you an e-mail, please reply it with the above-mentioned information and we will do our best to fix the issue.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!