Forum Discussion

Khaled_Ashraf's avatar
Khaled_Ashraf
Copper Contributor
Nov 24, 2022
Solved

Extra text shown in the cell but not in the formula bar

Hello everyone, there is an extra text shown in the cell but not in the formula bar.  Target is to clone the the cell to other sheet with formula but i do not want to have this extra Text "String I...
  • Riny_van_Eekelen's avatar
    Nov 24, 2022

    Khaled_Ashraf That cell F2 does contain the entire string where the words are separated by line feeds (i.e., invisible characters) that cause a text to jump to a new line within the cell when "Wrap text" is activated. Deactivate Wrap Text and you'll see the entire string without spaces in between.

     

    Make the formula bigger and then you see that everything is in one cell:

    If you want to return only the first line of this multi-line cell, use a formula like this:

     

    =LEFT(F2,FIND(CHAR(10),F2)-1)

     

    where CHAR(10) is the code for a line feed.

     

Resources