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 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?
