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. :)

22 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

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

How satisfied are you with this response?

Thanks for your feedback.

 
 

Question Info


Last updated July 31, 2020 Views 7,675 Applies to: