I have a data in excel, example shown below

```
Column1 (Cell A1)
A

B

```

[![enter image description here](https://i.stack.imgur.com/NVHID.png)](https://i.stack.imgur.com/NVHID.png)

**P.S.** - The value shown above are in 1 single cell and not 3 rows. (So, Char(10) is like a blank line cell value looks like below)

I need to remove the new line characters (Blanks) in between that cell value.

Output example,

```
Column1
A       
B

```

There are number of cells like this in my column.

My efforts:

I tried to do this with replace/substitute the Char(10) character but that removes all Char(10) and I get wrong output,

```
SUBSTITUTE(Column1,CHAR(10),"")  

```

Wrong output:

```
Column1
AB

```

Could anyone please suggest a solution to achieve this? I can try something else as well to resolve this issue.