0

Is there a way to dynamically delineate an Excel text cell by semicolons such that the two words are then stacked in a column?

For example:

word1;word2

word3

becomes:

word1

word2

word3

I cannot use macros or any sort of script/wizards. And I need it to be a formula so that it updates automatically/dynamically.

Is this possible?

5
  • Yes it is possible.
    – Eric F
    Nov 6, 2015 at 20:18
  • Is there a reasonable way to do it? I can do it in a super convoluted way. Can you elaborate on how? Thanks!
    – celine36
    Nov 6, 2015 at 21:59
  • Are you open to a vba solution?
    – Eric F
    Nov 7, 2015 at 17:21
  • Thanks, but no, I can't use a VBA solution unfortunately.
    – celine36
    Nov 16, 2015 at 2:04
  • You cannot do this without macros (vba coding). Feb 4, 2019 at 23:16

0

You must log in to answer this question.

Browse other questions tagged .