Hi Guys,
Could you please help me to find what I missing in the following formula :
=IFERROR(LEFT(A2,FIND(CHAR(10),A2)-1),A2)
The result of this is CERO and I want to have nothing
Capture.JPG
example.xlsx
Hi Guys,
Could you please help me to find what I missing in the following formula :
=IFERROR(LEFT(A2,FIND(CHAR(10),A2)-1),A2)
The result of this is CERO and I want to have nothing
Capture.JPG
example.xlsx
Change the end to "" instead of A2
=IFERROR(LEFT(A2,FIND(CHAR(10),A2)-1),"")
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
Thanks for the quick reply dosydos. Do you know what need to be added to keep the result for example :
Capture2.JPG
With the Original formula I have the text as result , but if A2 have text but with the new formula "" at the end is blank . There is a possibility to have the text but if A2 is blank avoid cero ?
whoops sorry about that try this formula instead:
=IFERROR(LEFT(A2,FIND(CHAR(10),A2)-1),IF(A2="","",A2))
One way:
=IFERROR(LEFT(A2,FIND(CHAR(10),A2)-1),A2)&""
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Ohh god you are amazing thanks a lot !!
It seems that you are no longer using Excel 2003. Please update your profile.
You're welcome.
It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.
Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks