c# – Replacing a | delimiter with a rn but keeping the text in the same column and cell

This was originally marked as a duplicate but the answer provided there was way off the mark.

I have a c# app that reads a text file and looks for ^ characters and replaces them with t. It also looks for | characters and attempts to replace them with rn. This .txt file should then be copied into a spreadsheet. The problem is that when the app replaces | it places the data into the first cell of a new row. I want it kept in the same cell / order it was originally with words separated by | forming sort of a vertical list within that single sell (a bit like a alt+Enter in Excel).

For example the input is:

This^is^testing^to^see|if|it|works

The output I need is:

This    is    testing    to    see 
                               if
                               it
                               works

Instead I get:

This    is    testing    to    see 
if
it
works

I am currently using:

 File.WriteAllText(textBox1.Text, File.ReadAllText(textBox1.Text).Replace("|", "rn"));
 File.WriteAllText(textBox1.Text, File.ReadAllText(textBox1.Text).Replace("^", "t"));

Where am I slipping up?

The closure of this question was of no help. rn does the same thing. I need the replacement of the | delimiter to keep the information in the same cell. As you can see it the above example it is moving it a row down into the A (first) column thanks to the n I assume.