Truncating Existing Entries

i want to truncate anything past the 7th character. is there a way to do this? The data is pretty uniform, usually has about 12-15 characters, if that helps.

Use a helper column of cells with a formula like:

=left(a1,7)

drag down.
convert to values and delete the original column if you want.


lrod1843 wrote:
>
> i want to truncate anything past the 7th character. is there a way to do
> this? The data is pretty uniform, usually has about 12-15 characters,
> if that helps.
>
> --
> lrod1843
> ------------------------------------------------------------------------
> lrod1843's Profile: http://www.excelforum.com/member.php...o&userid=24346
> View this thread: http://www.excelforum.com/showthread...hreadid=387172

--

Dave Peterson

works great. thanks!