software

I need to import some stuff up to a SQL DB. The problem is that the
cells that I have to upload contain more than 256 characters each, and
I get error messages. Is there a way to trim the contents of the cell
down to just the first 256 characters in the cell?

It's basically keywords that I'm uploading, so it's ok if they get cut
off at 256, even in the middle of a word.

Thanks, it's been driving me nuts--
method373
------------------------------------------------------------------------
method373's Profile: www.excelforum.com/member.php...oamp;userid=29888
View this thread: www.excelforum.com/showthread...hreadid=511444Use a helper column alongside the one you have, enter (Presumes column A)

=LEFT(A1,256)

and copy down. Now Editgt;Copy this new data and Editgt;Paste Special...gt;Values
over the old data and delete the 'helper column'

All you text will now be 256 characters wide

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HISquot;method373quot; gt; wrote
in message ...
gt;
gt; I need to import some stuff up to a SQL DB. The problem is that the
gt; cells that I have to upload contain more than 256 characters each, and
gt; I get error messages. Is there a way to trim the contents of the cell
gt; down to just the first 256 characters in the cell?
gt;
gt; It's basically keywords that I'm uploading, so it's ok if they get cut
gt; off at 256, even in the middle of a word.
gt;
gt; Thanks, it's been driving me nuts
gt;
gt;
gt; --
gt; method373
gt; ------------------------------------------------------------------------
gt; method373's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29888
gt; View this thread: www.excelforum.com/showthread...hreadid=511444
gt;

thanks so much, you guys are the best!--
method373
------------------------------------------------------------------------
method373's Profile: www.excelforum.com/member.php...oamp;userid=29888
View this thread: www.excelforum.com/showthread...hreadid=511444