LinkBack URL
About LinkBacks
Hello ,
I am needing to display more than 255 Characters in a cell. Is there any way I can do this?
Hello ,
I am needing to display more than 255 Characters in a cell. Is there any way I can do this?
An alternative is to wrap the text.. would that help?
Use 2 cells and split the text into 2 cells.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Here is my issue I am needing to make an if function. The issue is the text I need to display is to long. I have even tried to shorten the characters but I cannot get the text under 255.
You get better help on your question if you add a small excel file, without confidential information.
Please also add manualy the expected result in your file.
With Excel 2013, what functions are you using that's preventing you from displaying more than 255 characters?
In the attachment, I have 520 characters in A2, Then I use this formula
=LEFT(A2, FIND("N", A2)) to pull out and display 400 characters in A3
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Put the text in a separate cell and refer to that cell in your IF statement.
How would I go about doing a IF statement with the text in separate cells?
Maybe this image will help. Untitled.jpg
Well, depends on what you're trying to do with the IF statement.
For example, you want the cell to say "Yes" if this long string of text has the word ardvark in it, and "No" if it doesn't. Instead of
=IF(ISNUMBER(SEARCH("ardvark", "This long string of text...ardvark.... that ends like this.")), "yes", "No")
put the long sstring of text in a cell (i.e. A1) and your IF now becomes
=IF(ISNUMBER(SEARCH("ardvark", A1)), "Yes", "No")
Putting the text in A2
=IF(A1=1, A2, "something else")
That worked. Thank you very much for your time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks