Search results for query: *

Thanks bluedragon2 and johnnygeo. Bluedragon2 - As I have to capture last 0-2 character(s) due to different data strings, I have modified your function so it can first count position of alphabetic character and then based on that split the string. Thanks a lot for giving me idea. Here is...

Hello Friends, I need help with splitting an alphanumerical string. I am using Excel to manage this data but if you have any better suggestion, please let me know. I have a string starting with numerical part which has at the end some soft of alphabetical character followed by 1-9 numerical...

Thank you. Bowers74 and TonyJollans for your solution. It worked for me and helped me a lot. Thank you very much.

Thank you for reply. I am new for Excel. Can you please help me to built a formula which i can put in cell to check for 1000s of patent numbers. Thank you in advance.

Hi, I am trying to determine Expiration date for patent in excel spreadsheet. WHAT I HAVE? File Date : Date when company filed application for patent, i. e. Publication Date : Date when patent office issue files application as patent i. e. RULE: patent expire after 20 years from file date...

group Count of Patent no code 1 2 3 4 Grand Total ---------------------------------------------------- 1.002.002 1 1 1.002.003 1 1 1.003.003 1 1 1.003.004 1 1 1.004.002 1 1 2.002.000 4 4 2.002.002 6 6 3.006.000 2 2...

Can you print something else? is file-> Print is highlighted or is gray?

Hi, I am stuck here in counting unique values in many-many relationship. Here is situation. I have three columns in my excel sheet, first for patent numbers, second for Product code for each patent and third is group no. for each product code. Data have one patent number to many product code...