Search results

p45Cal Thanks for the attention

Good afternoon, I disturb your attention I found the FirstNonDigit(xStr As String) function on the Internet, but it does not count blank spaces, as you can see in the attached file I would appreciate modifying, or making a new, macro or function, so that it takes into account the spaces, and...

Thanks p45cal, It's correct. Sorry for the disturbances God grant you health, personal, family and work well-being, until another opportunity Regards (Translated with Google translator)

Gracias Marc, lo compruebo Saludos

Thank you very much p45cal. I appreciate your help for me. I've been testing it and it works well, I just need to solve two observations: 1) The first is that it only lists the folder that I select, but not the folders that are inside it. That is, it needs to be extended so that it also...

Thanks Marc, for your collaboration. Unfortunately I have never written a code, and I believe that with my 68 years, although it is never too late to learn, I will soon write one. If it is true, that I am registered in the forum many years ago, the times I have asked for your help has been...

I would appreciate if you can help me It should appear, where indicated, an almanac to choose dates 1 and 2. Then it must show the option to choose the folder from which we want to list the files that have been modified between the dates indicated...

Sorry they have not reached a book, since it can be any file that has more than one sheet to be able to select, and convert to PDF. If it is necessary to attach the books, I will appreciate communicating Thank you Note: translated into Google translate from Spanish

Good afternoon, sorry for the inconvenience, I need from book A, convert the sheets of another book B to PDF. The procedure that must be followed is the following: 1) From book A I should look for book B and open it 2) Have the option of being able to select the pages of Book B that I want to...

It's Windows 10, and Excel is 2016 (from 365), both are only Spanish. Excel your language is set as the Windows default, ie it is Spanish Greetings Jorge

Thank you Marc L, it worked out perfect. Regards Jorge

Narayan, Good morning, thank you for your prompt reply. The truth is I do not know where the error is, or what is happening. I send you 2 images so you can see the results. My excel does not allow me to translate formulas from English to Spanish, even in the event that I record the file with the...

Narayan, thank you very much, unfortunately does not give the suggested result. Note in the attached file in Feuil2, that for both cases results in the formula in English, which I had requested to translate into Spanish. Thanks for the attention, I hope you have another suggestion Regards

Narayan, Thank you very much, I have already reviewed them, but what happens is that in the first link, "piuha" translates function by function, in a formula you would have to be looking for one by one. In the case of the second, "excel translator", it is necessary to have internet, it is...

Hello dear friends good morning, I want to make an appointment, today, early browsing the forums of excel, looking for information about translating formulas from English to Spanish, I found in the following link https://www.excel-downloads.com/attachments/fonctionafficheformule2-xls.66651/...

Narayank, thank you very much for the links, I could know more than I knew Lori: I'll be grateful to tell me how you do to get the result A2 = "a ss ddd ffff ggg hh j" -> {"ss"; "hh"} to me it only gives me the result "ss", it does not give me the second or third event, when there is. In our...

Lori, thank you very much for your kind attention. I have Excel16 in Spanish, and the translation of your formula is: I can not find translation for what is red I'll be grateful to you how you do to get the result A2 = "a ss ddd ffff ggg hh j" -> {"ss"; "hh"} to my...

Narayank, thank you very much for your kind attention, it shows your generosity and professionalism. Until another opportunity, they can give the subject by closed Jorge from Perú P.D .: translation made with Google Translate

Good afternoon, excuse the insistence, if it is within the reach of someone would be good to explain the applied formulas, and because "rng" is defined as Unless I propose another solution Thank you,greetings from Peru Jorge P.D .: translation made with Google Translate

John Jairo V, I have had the opportunity to do the corresponding tests and it works correctly, very good job. I would be grateful if you please kindly explain why the use of each of the formulas used and how they have been built nesting with each other, as well as the formula used for the {rng]...

John Jairo V, thanks for your attention, I will verify results with the original data, and I am communicating with you. Welcome will be any other suggestion. Thank you very much Jorge from Peru

r2c2, thanks for your attention. Good morning here in Peru, a query, the parameter "delim", what it serves, how it is used give some examples of application. With the explanation that you made me arrive if the other occurrences are obtained, excellent. While this UDF is very useful, it has the...

r2c2, thanks for your attention. Please check the attached file, you can see cells in yellow, which are well obtained results, and in blue results that give error, or that does not find, is the case of a second or third word that may be in the text of the cell . Please check the UDF, give some...

Good afternoon, dear friends. I want to know how I can do, either with formula, macro or UDF, to get words from a cell that have a certain number of characters. Attached file with examples. Thank you in advance for the attention. Greetings from Peru Jorge

Thank you Narayan and Bosco for the explanation Until another opportunity, greetings from Perú Jorge