Limit or truncate characters in a field/column

[ImgPro]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have a table with a column which contains 16 characters in each record. I want to eliminate every thing after the 11th character. Can this be done? I'm a real amateur at Excel and hope one of you pros will have a simple answer as to how I can do this. Thanks in advance.

 

[CyberTaz]

Shouldn't be too tough - Assume your data is in A10:F100 and the specific
column is Column D:

Create the following formula in cell G10: =LEFT(D10,11)

Copy the formula down to G100

Select & copy G10:G100 then go to D10

Use Edit> Paste Special - Values

Clear the content of G10:G100

 

[ImgPro]

Very good, Bob. Took me a minute to figure out your formula and how to use it, but once I did it worked like a charm. Thanks.

 

[CyberTaz]

You're most welcome! Glad I was able to help.

Regards |:>)
Bob Jones
[MVP] Office:Mac