econometricks - replacing newline characters in a spreadsheet

sharing things i learn about data manipulation, econometrics, and related tools. should it ever prove useful to you, i would love to hear how.

replacing newline characters in a spreadsheet

wanted to remove newline characters / carriage returns from inside of cells in a spreadsheet.

First, I needed to determine the character code of the newline character. I pressed F2 to enter cell edit mode and selected just the newline character, copying and pasting the character into a new cell. I used CODE() to determine the character code - it was 10.

I could then use SUBSTITUTE(<source cell>, CHAR(10), “”) to remove the newline character.

Comments (View)