Replace inline breaks with new lines excel

I have a heap of poorly formatted Excel sheets All the data is in one cell with alt+"enter" inline breaks between the lines. I would like all the values on different lines. I was thinking of doing a find-and-replace search for "alt+010" What do I replace it with? Can this be achieved in VBA

Similar question here here

Answers


This can be done as a two step process

  1. Text to Column - use Delimites, Other, Ascii code 10 (Alt 0010 on the numeric keypad)
  2. Copy, Paste Special, Transpose

Need Your Help

How can I block the keyboard from appearing even though I need to set my webView contentEditable=true?

javascript html ios cocoa-touch uiwebview

I am using a webView to display text content, and I am trying to use javascript to highlight text that the user selects. This becomes possible when contentEditable = yes, but that also brings up the

Sending and receiving broadcast from the same receiver

android broadcastreceiver android-broadcast android-geofence

Hello I was trying to implement a custom Broadcast receiver for my Geofence app. I just went through the solution given here But I found that he is sending the broadcast from the receiver class which