Search results

thanks

Good morning. I would like to extract from the contents of cells the content up to before the round bracket. In this example: PALMA DI MONTECHIARO (AG) the result is: PALMA DI MONTECHIARO Thank you

macro to undo spaces throughout the table Good morning. Could you help me create the code to select the excel file and apply the formula cancel preceding and trailing spaces from all the columns of the table present in the excel file? Thank you

It worked. Thank you

Excel 2010 at work, Office 2021 Professional at home

Good evening. I joined data present in different cells with the concatenate in column "I" and checked whether this is the same as that in column "A". Because they are different (the equality in the "J" column is "NO"). If I copy and paste the entire "I" column, a trailing space appears which, if...

I've tried yours, the other one seems to be can't be translated or doesn't exist in Italian

Now works. Thank

I translated the formulas into Italian but they don't work =ESTRAI(A2;TROVA(")";A2;1)+2;TROVA("-";SOSTITUISCI(A2;" ";"-";LUNGHEZZA(A2)-LUNGHEZZA(SOSTITUISCI(A2;" ";""))))-TROVA(")";A2)-2) =TESTOPRIMA((TESTODOPO(A2;")"));" ";-1)

Good morning. Could you help me find the right formula to extract the street addresses as in the orange column? I tried with python but it cuts the first part. Thank you

I would need formulas suitable for Office 2021 professional and 2010

on the site indicated above I cannot translate the formulas into Italian. How come? I use Office Professional 2021 at home

Good evening. Maybe it will be explained to me badly. The formulas in the blue cells were already working. I can't create the orange cell formulas to extract the data you see. I tried using this site: https://it.excel-translator.de/translator/ However, it doesn't work to translate the formulas...

HI. Can you help me break down the addresses in a column. I have already inserted two formulas that work, the others don't work. to search for the postcode it would be enough to find the string made up of 5 digits without spaces with a subsequent and preceding space. There are commas that...

if I put a comma instead of a period, the calculation works even if the formatting occurs as text. The problem is the formula. Why do they sometimes work and sometimes they don't? If I don't paste as text the data is recognized as a number and not as coordinates

the excel file is large for uploading. I paste the colon headers for each file below. country code postal code place name admin name1 admin code1 admin name2 admin code2 admin name3 admin code3 latitude longitude accuracy geonameid name asciiname alternatenames latitude longitude feature...

on the geonames website you can find files on the cities and geographical coordinates for each state. For the links below I downloaded the IT files. I did the copy and paste as text otherwise the coordinates in the excel file appear as numbers. LINK: http://download.geonames.org/export/dump/...

HI. I opened your file and the distance appears even if the coordinates are expressed with a ".". To obtain the same value, however, I would have to replace the dot."" with the comma",". Then the only formula that works for me is that from 440 m it becomes 11000 (if the "." is used). The forest...

I have already tried several times and it does not work otherwise I would not have asked for help :)

In the other cells does not change what you see.

I tried to do as you wrote but nothing changes

I seem to have understood that at the coordinates I have to replace the period with the comma. Then the formulas in columns "k", "l" and cell O3 appear as if there were no "=" before the formula or I find "#NOME?"

Could someone help me?

Good morning. I'm having trouble with a formula for calculating the distance between two points in km and meters. In the first sheet you will find the formulas that I have tried but which do not work well. Thank you

okay, then excuse me