Separating multiple data entries in field

[mrpeanutman]

Hey,

I imported my contact database into a table and am trying to separate these years so that "2019; 2020" would turn into multiple datapoints that can be filtered accordingly like "2019, "2020" etc. Is there any easy way to do this? Thanks!

[Dan_Montoya]

try converting the field to multi-select field.

[Dan_Montoya]

you may have to convert the ; to , first.  Remember, you can always "undo" if the conversion doesn't do what you wanted or restore a snapshot.

[TheTimeSavingCo]

Try this:
1. Create a new formula field with this formula:

SUBSTITUTE(
  {Refresh},
  ';',
  ','
)

 2. It should now look like this:

3. Edit the new formula field and convert it to a multiple select field.  It should now look like this: