Hi,
I have a column of strings containing substrings, which are divided by a blank space. I would like to split the substrings into the subsequent cells using the xml.filter function. Some substrings contain a blank space in themselves and should not be divided. So the substring "John Williams" should stay one substring instead of two.
How can this be done with a xml filter function?
If you are actually using 2013 as your profile says, you don't have that function...
You could use a quote followed by a space as the delimiter based on that sample data.
Rory
How aboutFormula:
Please Login or Register to view this content.
I though it came out in 2013.If you are actually using 2013 as your profile says, you don't have that function...
You're right - my mistake. I thought it originated in 2016 but I just checked the docs. Apologies to Maarten!Originally Posted by Fluff13
@ Rorya, no problem
@ Fluff13, thanks that works great!
@MaartenRo
If you have moved on from Excel 2013, please update your profile. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Glad to help & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks