•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
FilterXML only returning one value
Our take
When working with call log analytics in Excel, users often seek efficient ways to manipulate data without advanced functions like TEXTSPLIT, especially in earlier versions like Excel 2019. The FILTERXML function can offer a creative solution for extracting specific elements from structured data. In this case, while the formula successfully retrieves dates, users may find challenges in extracting corresponding times. This guide will explore how to refine your FILTERXML approach to achieve a streamlined extraction of both date and time values for enhanced productivity.
| A | B | C |
|---|---|---|
| 1 | Call Time | Date |
| 2 | 2026-01-07T11:27:00 | 1/7/2026 |
| 3 | 2026-01-07T11:25:29 | 1/7/2026 |
| 4 | 2026-01-07T09:48:04 | 1/7/2026 |
| 5 | 2026-01-14T09:11:32 | 1/14/2026 |
| 6 | 2026-01-14T08:52:47 | 1/14/2026 |
| 7 | 2026-01-21T14:15:00 | 1/21/2026 |
=FILTERXML("<everything><item>"&SUBSTITUTE(A2,"T","</item><item>")&"</item></everything>","//item") I'm working on some call log analytics in standard Excel. and struggling to streamline things. In order to help shorten the work time involved I'm trying to use a formula to perform the "text to column" task with a formula. Unfortunatly I don't have Excel365 so I can't use the =Textsplit function, but I found the FilterXML function. This video got me a useable formula for the date, but I'm not sure what I need to do to return the time. I'm completely out of my depth on this one.
Anyone have ideas?
***Edit*** I'm using Microsoft® Excel® 2019 MSO (Version 2604 Build 16.0.19929.20086) 64-bit
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#AI formula generation techniques#Excel compatibility#real-time data collaboration#real-time collaboration#formula generator#Excel alternatives#rows.com#natural language processing for spreadsheets#self-service analytics tools#generative AI for data analysis#financial modeling with spreadsheets#no-code spreadsheet solutions#predictive analytics in spreadsheets#predictive analytics#self-service analytics#Call Time#Date#Excel#formula