Thread: For the Excel Pro: Cell Formatting Question?
View Single Post
Old 01-07-2011, 12:24 PM   #8
InvisibleSoul
The RS Freebie guru
 
InvisibleSoul's Avatar
 
Join Date: Jul 2001
Location: East Vancouver
Posts: 22,032
Thanked 2,491 Times in 860 Posts
Failed 137 Times in 67 Posts
=CONCATENATE(LEFT(A1,5),"…")

or

=LEFT(A1,5)&"…"
InvisibleSoul is offline   Reply With Quote