contained

I would like to download text files (extracting those contained in zipped files - excluding the readme file) contained in this page wew: http://download.geonames.org/export/dump/ can you help me

Hi Mr.Excel, I am looking for vba code or formula where I can search number in the given column (this column combination of numbers, text and special characters). In this I would like to take only number which I require or entire cell which contain the requested number, if provided number does...

Hello everyone, I have a quick question. Using the FIND or SEARCH Function in Excel I can check wether a cell contains a specific content, e.g. =FIND("Denmark",A1) checks the cell A1 for the word Denmark and returns the position if the word is contained in the cell. Now I have a huge dataset...

Hi folks, I'm hoping someone might have a formula for this use case. I have a sheet containing a column of data values. the values are like this: Updated_New_Customer_DE 2016_w32_1_Sunday_ladies [example] I would like to use a formula to extract the value either after the last underscore_ or...

hi there, i have a sistematic problem with data and i have to be creative with exported data for them to be usable. i deal with products that have certain ID problem is One product can have MORE diffreretnt ID's. I coded an export to combine all ID' that refer to same product in one CELL (ref...

Hello, I'm new to the forum, and I come with a question. I am working with 2 sprea sheets which contain a list with collumns: program, Implementation notes, version, and description. One of the list is more recent, and thus, the older version is missing some of the rows in the newer one. I...