Forum Discussion

JoseIConde's avatar
JoseIConde
Copper Contributor
Aug 03, 2023

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...
excel
Formulas and Functions
JoseIConde's avatar
JoseIConde
Copper Contributor
Aug 03, 2023
Yes, sorry, I mean a line break. It's OK replacing it with a blank space.
Thank you for your help.
HansVogelaar's avatar
HansVogelaar
MVP
Aug 03, 2023

JoseIConde 

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?

  • JoseIConde's avatar
    JoseIConde
    Copper Contributor
    Aug 03, 2023

    HansVogelaar , https://idice-my.sharepoint.com/:x:/g/personal/jiconde_idice_es/EdNLkkVIWDZMtC8U5tj95KcBrTdU89vDy8FDNLHVqV4wcA?e=mDrblW you have the sample. The problem is located in column C.

    Thank you so much for your help.

    KR

    José

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Aug 03, 2023

      JoseIConde 

      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's avatar
        JoseIConde
        Copper Contributor
        Aug 04, 2023
        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.

Resources