How to get city addresses?

Question

excel

Good day. Please tell me how to get all the addresses of the city from the fias database or where else you can do a similar operation.
Example: the city of Cholsk, st. Sverdlova d. 1, 2, 3, 4, 4a, 5.7 ... etc.
The fact is that I will need to divide the streets and addresses of houses into the corresponding sections.

Answer 1

According to your example:
in cell A1 there is an entry: the city of Chelsk, st. Sverdlova d. 1
In cell B1 we write: = RIGHT (A1;
we take cell A1 and pick up the characters on the right in the call Length of the entire record A1 ( DLSTR (A1) ) minus - the number of characters up to 1 comma (the one after the settlement) ( SEARCH (","; A1) - will return serial number of the first character "," from cell A1) and also add -1 to remove the space before str.