Cannot put the following string in a cell

39 views
Skip to first unread message

Timothy Parez

unread,
May 17, 2009, 2:49:42 AM5/17/09
to excellibrary
Hello,

Don't ask why (:p) but I have to store the string below into a cell.
When I do, Excel considers this to be formula and renders the document
invalid.

How can I force it to be handled as text instead of a formula?

Thank you.


Sample string: (this needs to go into a single cell)!


"7-Zip 4.42 (2.9 MB);AC3Filter (remove only) (4.0 MB);Acrobat.com
(Onbekend);Acrobat.com (1.7 MB);Adobe AIR (Onbekend);Adobe AIR
(Onbekend);Adobe Flash Player 10 ActiveX (Onbekend);Adobe Flash Player
Plugin (Onbekend);Adobe Reader 9.1 (139.0 MB);ALPS Touch Pad Driver
(1.4 MB);ATI - Software Uninstall Utility (108.0 KB);ATI Control Panel
(15.8 MB);ATI Display Driver (Onbekend);Broadcom Gigabit Integrated
Controller (Onbekend);Broadcom Gigabit Integrated Controller
(Onbekend);Citrix ICA Client (8.0 MB);C-Major Audio [english (united
states)] (736.0 KB);Compatibility Pack for the 2007 Office system
(88.4 MB);Conexant D110 MDC V.9x Modem (524.0 KB);Configuration
Manager Client (Onbekend);DAEMON Tools (601.0 KB);Dell ResourceCD (2.7
MB);eXe -- eLearning XHTML editor (58.1 MB);HP Officejet 5600 series
(Onbekend);Image Resizer Powertoy for Windows XP (17.0 KB);Intel(R)
PROSet/Wireless Software (17.0 MB);Internal Network Card Power
Management (608.0 KB);J2SE Runtime Environment 5.0 Update 6 (119.4
MB);Java 2 Runtime Environment; SE v1.4.2_13 (108.8 MB);LANDesk(R)
Common Base Agent 8 (Onbekend);LANDesk(R) Software (80.9 MB);LANguard
Network Scanner (3.5 MB);McAfee AntiSpyware Enterprise Module (24.3
MB);McAfee SiteAdvisor (6.5 MB);McAfee VirusScan Enterprise (17.6
MB);mCore (Onbekend);mDriver (Onbekend);mDrWiFi (Onbekend);mHlpDell
(Onbekend);Microsoft .NET Compact Framework 1.0 SP3 Developer (9.9
MB);Microsoft .NET Compact Framework 2.0 (59.3 MB);Microsoft .NET
Framework 1.1 (Onbekend);Microsoft .NET Framework 1.1 (36.1
MB);Microsoft .NET Framework 2.0 Service Pack 1 (185.8 MB);Microsoft
Application Error Reporting (Onbekend);Microsoft Application Error
Reporting (Onbekend);Microsoft Application Error Reporting
(Onbekend);Microsoft Device Emulator version 1.0 - ENU (1.4
MB);Microsoft Document Explorer 2005 (26.6 MB);Microsoft Document
Explorer 2005 (Onbekend);Microsoft Exchange Server 2007 (548.5
MB);Microsoft Exchange Server Best Practices Analyzer Tool (15.2
MB);Microsoft Exchange Server (Onbekend);Microsoft Exchange
Troubleshooting Assistant (6.4 MB);Microsoft Exchange
(Onbekend);Microsoft FrontPage Client - English (Onbekend);Microsoft
Group Policy Management Console with SP1 (6.3 MB);Microsoft
Internationalized Domain Names Mitigation APIs (Onbekend);Microsoft
Kernel-Mode Driver Framework Feature Pack 1.5 (Onbekend);Microsoft
National Language Support Downlevel APIs (Onbekend);Microsoft Office
2003 Proofing Tools (807.5 MB);Microsoft Office Professional Edition
2003 (733.4 MB);Microsoft Office Project Professional 2003 (210.3
MB);Microsoft Office Visio Professional 2003 (379.8 MB);Microsoft
Report Viewer Redistributable 2005 (91.5 MB);Microsoft Report Viewer
Redistributable 2005 (Onbekend);Microsoft SQL Server 2000 (119.9
MB);Microsoft Virtual PC 2007 (36.8 MB);Microsoft Virtual Server 2005
R2 SP1 (49.6 MB);Microsoft Visual C++ 2005 Redistributable
(Onbekend);Microsoft Visual J# .NET Redistributable Package 1.1 (11.4
MB);Microsoft Visual Studio .NET Enterprise Architect 2003 - English
(638.7 MB);Microsoft Windows Server Update Services 3.0 Console (98.9
MB);Microsoft Windows Server Update Services 3.0 (Onbekend);mIWA
(Onbekend);mIWCA (Onbekend);mLogView (Onbekend);mMHouse
(Onbekend);Mozilla Firefox (3.0.5) (25.6 MB);mPfMgr (Onbekend);mPfWiz
(Onbekend);mProSafe (Onbekend);mSSO (Onbekend);MSVC80_x86
(Onbekend);MSXML 4.0 SP2 (KB936181) (2.6 MB);MSXML 4.0 SP2 (KB954430)
(2.7 MB);MSXML 6 Service Pack 2 (KB954459) (1.3 MB);mToolkit
(Onbekend);mWlsSafe (Onbekend);mXML (Onbekend);mZConfig
(Onbekend);PowerDVD 5.1 (1.7 MB);QuickSet (9.8 MB);RDC
(Onbekend);SafeGuard� PrivateCrypto 2.11.0 - Unlicensed Version (9.1
MB);Sonic DLA (2.6 MB);Sonic RecordNow! Plus (38.5 MB);Sonic Update
Manager (900.0 KB);Texas Instruments PCIxx21/x515 drivers.
(Onbekend);TI_Inst (Onbekend);TOSHIBA ConfigFree (19.8 MB);Update
Rollup 6 for Exchange Server 2007 Service Pack 1 (KB959241)
(Onbekend);Visual Studio .NET Enterprise Architect 2003 - English
(Onbekend);Visual Studio.NET Baseline - English (Onbekend);VMware
Infrastructure Client 2.5 (54.9 MB);VMware Infrastructure Update (2.7
MB);VMware Remote Console Plug-in (43.8 MB);VMware Server (490.8
MB);VSPropertyGenerator (219.0 KB);WebFldrs XP (Onbekend);WIMGAPI
(304.0 KB);Windows Driver Package - Nokia Modem (03/05/2008 3.7)
(Onbekend);Windows Driver Package - Nokia Modem (03/13/2008 6.86.0.1)
(Onbekend);Windows Driver Package - Nokia Modem (05/22/2008 3.8)
(Onbekend);Windows Driver Package - Nokia Modem (05/22/2008 7.00.0.1)
(Onbekend);Windows Driver Package - Nokia Modem (08/03/2007 6.84.0.2)
(Onbekend);Windows Driver Package - Nokia Modem (10/12/2007 3.6)
(Onbekend);Windows Genuine Advantage Notifications (KB905474)
(Onbekend);Windows Genuine Advantage v1.3.0254.0 (Onbekend);Windows
Genuine Advantage Validation Tool (KB892130) (Onbekend);Windows
Genuine Advantage Validation Tool (KB892130) (Onbekend);Windows
Installer 3.1 (KB893803) (Onbekend);Windows Internet Explorer 7 (2.7
MB);Windows Live aanmeldhulp [dutch (netherlands)] (1.3 MB);Windows
Live installer [dutch (netherlands)] (2.3 MB);Windows Live Messenger
[dutch (netherlands)] (31.4 MB);Windows PowerShell(TM) 1.0
(Onbekend);Windows Resource Kit Tools (18.7 MB);Windows Server 2003
Service Pack 2 Administration Tools Pack (32.1 MB);Xvid 1.1.3 final
uninstall (788.0 KB)"




Liu Junfeng

unread,
May 22, 2009, 5:30:02 AM5/22/09
to excell...@googlegroups.com
I created a file contains this string, and it works well.

LiuJF

unread,
May 22, 2009, 5:46:57 AM5/22/09
to excellibrary
See Book1.xls in Files.

On 5月22日, 下午5时30分, Liu Junfeng <china.liujunf...@gmail.com> wrote:
> I created a file contains this string, and it works well.
>
> > uninstall (788.0 KB)"- 隐藏被引用文字 -
>
> - 显示引用的文字 -
Reply all
Reply to author
Forward
0 new messages