Trimming a cell down to 256 Characters

M

method373

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
 
N

Nick Hodge

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

=LEFT(A1,256)

and copy down. Now Edit>Copy this new data and Edit>Paste 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
[email protected]
 
Top