Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Max number of characters in a cell in Excel?
I'm using Excel 2007. The maximum number of characters in a cell is a little over 32,000
I'm having an issue with this because it is not enough for some of the stuff I'm currently doing.
I have searched online for the specs for Excel 2010, the newly announced version of Excel (Excel 2012?) and OpenOffice, but I have not found any information about this.
3 Answers
- ?Lv 45 years ago
if it is purely an issue-free count of truncating the textual content cloth, then left(a1,50) could be adequate. you are going to be able to need a macro to strip each and all of the vowels off yet then the outcomes could not be % you particularly need. One determination is to sparkling out the unique values making use of strengthen clear out ideas. replica this checklist of unique values to a clean sheet, placed them in column A. In column B, enter the shortened textual content cloth manually making use of the suited acronymns or short words. go decrease back to the unique sheet, do a vlookup, you presently have a shorten textual content cloth in a clean column. key words to hunt: stepped forward clear out, unique, vlookup
