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
HansVogelaar's avatar
HansVogelaar
MVP
Aug 03, 2023

JoseIConde 

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

And what do you want to replace it with?

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.

Resources