hash

Hi I just noticed that Excel hyperlink won't be able to open a file that has pound sign (Hash #) in the file name. One solution is to rename those files. However, I have so many files with (#) in their name which not possible solution. Any thought on how to solve this issue?

The lower table refers to the upper table. The upper table is somewhat successfully dynamic (side note: if I could use: =SUMIFS($G$4#,$M$4#,$O4#,$K$4#,Q$3#) instead of: =SUMIFS($G$4:$G$1000,$M$4:$M$1000,$O4#,$K$4:$K$1000,Q$3#) that would be cool) Is there any way to modify my formulas in the...

I have a spreadsheet that has 7 columns of URLs and i need to place a double hash tag between each URL row a is my mpn row b is my image name row c is the first set of URLs row d is for the (2) ## hash tags row e is my second set of URLs row f is for 2 hashtags row g is my third set of URLs...

Hey, I have a bunch of files with similar names but I only need to list the ones that contain "#" character. I tried a couple of ways but no luck. File list: Intercompany Recs Bulgaria # 0059.xlsb Intercompany Recs Bulgaria ∣ 0059 - Copy.xlsb Intercompany Recs Bulgaria ☠ 0059.xlsb Intercompany...

Hi, does anyone know a way to give a hash value of a whole excel workbook? I need to quickly compare two workbooks that have 20+ tabs as quickly as possible, without uploading them to a dodgy website.

Forgive me if this has been request before, any assistance is greatly appreciate. I have the data below consisting of thousands of rows. I need to isolate rows only where the field1 and field2 columns match. is there a quick method of performing this in excel? <colgroup><col span="2"...

I have a spreadsheet with a range name matrix The first row of matrix is the Year # and each row is a different category with many subcategories. See Below 2000 2001 2002 … Insurance Health Auto Fire Theft Utilities Electric Gas Sewer...

I am using Excel 2003 in the UK - where shift+3 is a pound sign (£) However, occasionally (and seemingly randomly) Shift+3 produces a hash sign (#). I have researched many forums online and the common 'solution' is suggesting to check that the Microsoft Office local language setting is UK (and...