Forum Discussion
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 Instance Daten" but just the "H_TÜ_Türnummer"
THANKS IN ADVANCE.
Kind regards,
Khaled
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.
4 Replies
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.
- Riny_van_Eekelen
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)
