Hi Jim,

Can you please give me a pointer as to what the problem is. There are a ton of queries in your file and multiple tables, but I don't know what you're trying to do, where the source data is and the desired result, which query I should be looking at, or which step.

Thanks,

Mynda

Mynda,

Sorry for the inconvenience.

The Excel file: Summer Camp 2021 Classes_20210705.xlsx

The Query: SC-Fine Arts.

Step: Extract Text After Delimiter.

The Column: Courses (Almost toward the end)

The issues: 1.4 Beginner Taekwon-Do 

After I perform this step (Extract Text After Delimiter) to extract texts after "space", some appear as Beginner Taekwon-Do  (rows 8, 13, 19, & 25) while some appear as Taekwon-Do (rows 1, 5, & 6), missing "Beginner"

CSV sources file included in a zip file (SC-Fine Arts.zip)

You may also refer tot eh video: https://www.loom.com/share/79dad25dc43247ad84e303786943c2d6

Hi Jim,

Thanks for pointing me in the right direction. 

Power Query thinks the space after the course number in rows 1, 5 & 6 is a different character to the space in rows 8, 13, 19 & 25. I tried replacing them, but wasn't able to fix it. As a workaround, you can split the column by number of characters, with 4 as the number and then delete the column with the course number.

Hope that helps.

Mynda

It's a non-breaking space - Chr(160) - which you can replace using the special characters list in advanced options.