N
N
NIKOFF2018-03-24 22:32:58
Google Apps Script
NIKOFF, 2018-03-24 22:32:58

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

2 answer(s)
A
Anton Kiselyov, 2018-03-26
@zamboga

1. write a macro
2. first paste everything, and only then use CTRL + H to replace unnecessary characters with "emptiness"

A
Alexander Ivanov, 2018-03-27
@oshliaer

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
5aba02ef6e9b3253891467.png
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
5aba03516b237273893919.png

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question