Forum Discussion
Extra text shown in the cell but not in the formula bar
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.
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.
Thanks alot for explanation. Could you please show me how to combine this formula with the cloning formula "=TÜ-EXportlist!F2"
Khaled_Ashraf Just replace every F2 in my formula with TÜ-EXportlist!F2
And, I note you work in German Excel. So, then the formula would look like this:
=LINKS(TÜ-EXportlist!F2;FINDEN(ZEICHEN(10);TÜ-EXportlist!F2)-1)
- Great Riny, thanks alot for your help and quick response 🙂