Is it possible to shorten all of my values in a certain column with a three dots at the end? Say shorten all by values to 25 characters? I am in need of creating a short description and thought this is probably the best way. Thanks
Is it possible to shorten all of my values in a certain column with a three dots at the end? Say shorten all by values to 25 characters? I am in need of creating a short description and thought this is probably the best way. Thanks
Try this:
=LEFT(A1,25) & "..."
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks