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.


--
lrod1843
------------------------------------------------------------------------
lrod1843's Profile: http://www.excelforum.com/member.php...o&userid=24346
View this thread: http://www.excelforum.com/showthread...hreadid=387172

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! :)


--
lrod1843
------------------------------------------------------------------------
lrod1843's Profile: http://www.excelforum.com/member.php...o&userid=24346
View this thread: http://www.excelforum.com/showthread...hreadid=387172