Hi folks, I thought I understood the text to columns feature but I guess I don't. I have attached a spreadsheet with a column A that contains an album name and the date it was released. I want to seperate this into 2 columns, column A being the album name and column B the album release date. I thiught I could just select the cells and click on text to columns, and then use "-" as the delimiter but this isn't working for me. Any advice here? Many thanks

Attached Files

for excel forum.xlsx (9.4 KB, 5 views)

There are different types of dashs. The one in your sample appears to be an m-dash. Try copying one of those characters to your clipboard and then paste that into the 'Other' character field when choosing a Delimiter.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Hello, I don't know what an m-dash character is, or where to findit on my keyboard, I tried everything that looked like a hyjhen and nothing worked, then I copied it from the column A cell and pasted into the delimeter field and it worked fine. Thanks for your help! I will mark this thread resolved.

FYI How to Type an En Dash and Em Dash on Windows and Mac Devices | Proofed's Writing Tips

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Good to know, thanks for the link

if you use Power Query in the User Interface the em dash is automatically identified in this Mcode

__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2505