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: http://www.excelforum.com/member.php...o&userid=29888
View this thread: http://www.excelforum.com/showthread...hreadid=511444

Use a helper column alongside the one you have, enter (Presumes column A)

=LEFT(A1,256)

and copy down. Now EditCopy this new data and EditPaste Special...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
HIS


"method373" wrote
in message ...

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:
http://www.excelforum.com/member.php...o&userid=29888
View this thread: http://www.excelforum.com/showthread...hreadid=511444

thanks so much, you guys are the best!


--
method373
------------------------------------------------------------------------
method373's Profile: http://www.excelforum.com/member.php...o&userid=29888
View this thread: http://www.excelforum.com/showthread...hreadid=511444