Answer the question
In order to leave comments, you need to log in
How to make sure that when you put numbers, extra characters are removed in Google Doc?
For example, I copied this number +38 (068) -777-5-777, pasted it into the table, how to make it so that extra characters would be automatically removed and the number became like this 380687775777?
Answer the question
In order to leave comments, you need to log in
1. write a macro
2. first paste everything, and only then use CTRL + H to replace unnecessary characters with "emptiness"
If the data is filled by an operator, then most likely, he will need a tool to normalize the data. It can be either a local program, such as a browser extension, or an add-on to the Tables themselves.
An example of how the plugin works.
The user opens a side menu, which remains open for the entire period of work
Adds a value from the buffer to the upper field, receives the result in the lower field. It is possible to fill the buffer with a new value automatically
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question