pound

Hello, I have this code: Dim xmlOBject As Object Set xmlOBject = CreateObject("MSXML2.DOMDocument.6.0") xmlOBject.async = False xmlOBject.Load ("https://www.boi.org.il/currency.xml")' just example URL and its load to the xmlOBject variable the XML resulte. Is there a way to convert a...

Hi, I need to split a cell into columns where the data is imported in 9 lines with each line being its own subject such as the below. Each line should be its' own column. Time of call: 17:17 Category: Dogs Subject: Lost Dog Caller: Mxxxxn Mxxxxxy Phone: 0xxxx0xxx4 Address: 3 XXXXXXXX DR ...

Hi, I have about 30 tables that hold prices of goods in categories. I have use the Append function to create a master price list by combining all the tables. When I add new items to the individual tables the Appended table updates nicely with the additional items. The problem I have that any...

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...