Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

worksheet function for returning a field inside a delimited lists

I’d like to have a function available that returns a specified field within a delimited list. I would pass the list, a delimiter and a field number as arguments to the function and it should return the value in that field.

For instance with the pipe separated list ”TEST1|TEST2|TEST3|TEST4| TEST5|||||||TEST|” in A1.
I’d like to use something like GetFieldInDelimitedList(A1;"|";5) and have it return “TEST5”.

Any equivalent formula will requires quite a lot of nested functions e.g.:
=MID(A1,FIND("([])",SUBSTITUTE(A1,"|","([])",4))+1,FIND("([])",SUBSTITUTE(A1,"|","([])",5))-(FIND("([])",SUBSTITUTE(A1,"|","([])",4))+1))

13 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Kristian Simm shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

5 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base