I have a column that contains a bit of data separated by commas. For example:
ROW 1: Teeth Cleaning, $150, John Smith
ROW 2: X-Ray, $400, Jane Doe
All this data is in one column because that is the way it is imported using zapier.
Now that the data is imported, I’d like to break the data up by the comma bracket. I’d figure this would involve creating 3 new columns that are formula generated:
Does anyone know of a formula that will pull data before the first comma for the service name and then for the second column have a formula that pulls data after the first comma and before the second comma?
Thanks for your help!