Replace intro into a Excel cell

Copper Contributor

I'm trying to replace intros into Excel cells. I've tried using the replace function, introducing Ctrl+J or Alt+010. It works in some cells, but it doesn't in others.

I've tried to change the cell format both into general or text, with no result.

I've also tried to copy & paste the column into a blank sheet and try to replace again and it hasn't worked either.

The original data comes from a csv file.

6 Replies


What do you mean by "intro"? Perhaps a line break?

And what do you want to replace it with?

Yes, sorry, I mean a line break. It's OK replacing it with a blank space.
Thank you for your help.


It seems unlikely that a csv file would contain line breaks in cells.

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

@Hans Vogelaar , here you have the sample. The problem is located in column C.

Thank you so much for your help.




Thank you!

When I search for a line feed (Ctrl+J), Excel finds 34 cells.

If I then replace them with a space, Excel replaces 37 instances - some cells must have contained more than one line break.

After that, no line breaks are found, as expected.

I have attached the result.

Thank you, Hans. I think we have done something when "sanitizing" the data, because it doesn't work with the original data. Let me review it and see what we have done.