•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
FilterXML only returning one value
| 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]
Want to read more?
Check out the full article on the original site