Forum Discussion
JoseIConde
Aug 03, 2023Copper Contributor
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...
HansVogelaar
Aug 03, 2023MVP
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.
JoseIConde
Aug 04, 2023Copper Contributor
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.