Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi - is it possible to use a single nonrepeating XML element in a cell formula?
I am bringing a date field from an XML source, eg. '23/11/2009', and don't just want to show it in a cell by itself. I want to use it in a cell for a heading, such as 'Report date: 23/11/2009' all as one string. So I would like a cell formula along the lines of '="Report date: " & {XML-ReportDateField} How do I get access to an XML field in a formula? Is there a syntax for this? All I can think of is to put it directly in to another cell, and make it invisible by setting its text colour to white. And then refer to this cell in my formula. This is a bit messy, especially if users want to play around with the spreadsheet, and accidentally delete this hidden cell. Any help would be greatly appreciated. Cheers Paul Smith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula for several IFs in 1 single line/cell ..?? | Excel Discussion (Misc queries) | |||
single cell formula | Excel Discussion (Misc queries) | |||
single cell formula | New Users to Excel | |||
How do I prevent a formula element from incrementing when copying | Excel Worksheet Functions | |||
How do I put more than 7 IF formula in a single cell? | Excel Worksheet Functions |