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

E

Eugene2019-10-15 23:20:51

What engine does snik.co run on? 2Reply

A

Andrey Silaev2016-09-15 13:02:48

Where can I find a PHP script to convert XLS or WORD to PDF using PHP? 1Reply

S

spbdi2014-09-08 16:55:09

How to copy rows found by specific word in MS Excel? 1Reply

M

Marina2022-04-05 10:45:06

How to increase the range of numbers by a certain formula? 0Reply

D

Denis Lenivi2020-11-19 12:35:57

Google tables. Synchronization of one cell in different sheets, is it possible? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question