Forum Discussion
Replace intro into a Excel cell
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 f...
Yes, sorry, I mean a line break. It's OK replacing it with a blank space.
Thank you for your help.
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?
HansVogelaar , here you have the sample. The problem is located in column C.
Thank you so much for your help.
KR
José
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.