There is a large database of addresses in Excel, in a format like: "Far street" must be converted to the format "Far street." Are there any functions for this?

C

C

CheesR2017-10-10 10:26:37

excel

CheesR, 2017-10-10 10:26:37

There is a large database of addresses in Excel, in a format like: "Far street" must be converted to the format "Far street." Are there any functions for this?

There is a large database of addresses in Excel, in a format like: "Far street" must be converted to the format "Far street." Are there any functions for this?

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

X

x67, 2017-10-10
@CheesR

=ПРАВСИМВ(A1;ДЛСТР(A1)-ПОИСК(" ";A1))&" "&ЛЕВСИМВ(A1;ПОИСК(" ";A1)-1)
или
=ПРАВСИМВ(A1;ДЛСТР(A1)-ПОИСК(" ";A1))&" "&ЛЕВСИМВ(A1;ПОИСК(" ";A1)-1)&"."

Similar questions

A

AlexCruel2021-01-08 20:29:31

Excel border selection bug? 0Reply

Q

qwertybnm2016-12-05 12:06:32

How to make hexagonal cells in Excel and random generation in them? 1Reply

T

tamweb2019-05-10 19:44:23

How to find duplicates in an Excel column and rename duplicates? 2Reply

S

Sjhhducsj2019-05-17 17:12:12

Does Excel allow price parsing? 1Reply

B

bender30002016-12-22 07:38:16

How to insert array(i) = array(i).ItemData(0) into the loop? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question