Ask a new question

Mac Excel 2011 - Text to Column - Carriage Return as delimiter

Hi there,

As the title suggests, I'm trying to use the Text to Column function with carriage return as the delimiter (trying to parse addresses). I've found some solutions online, but they all seem to be for Windows. Has anyone been able to do this on a Mac?

Appreciate any help!

Answer
Answer

Hi there,

As the title suggests, I'm trying to use the Text to Column function with carriage return as the delimiter (trying to parse addresses). I've found some solutions online, but they all seem to be for Windows. Has anyone been able to do this on a Mac?

Appreciate any help!

For anyone who is curious, I managed to figure this out. Someone provided a solution on another thread:

  1. Convert the carriage returns to commas with  =SUBSTITUTE(A1,CHAR(10),",")
  2. Copy the result of above and paste special Value into another cell
  3. Use Text to Columns (Data tab, Data Tools group)

However, it should be CHAR(13) not CHAR(10), that's where I had trouble. Not sure if this is a difference between Windows and Mac, but once I made the change, I was able to get it done. :)

42 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated April 25, 2024 Views 16,370 Applies to: