Format Cell Text length?

X

xltmike

New Member
Joined
Oct 24, 2007
Messages
3
If I have cells with various words in varied length, is there a way to format the cell to display only the first 3 characters, the first 5 characters, etc... while the actual cell contents are say 20 characters?

I have never had a request like this before so please excuse me if it is an obvious answer...

Thank you
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
Sort by date Sort by votes
Welcome to the board...

You could use a formula in another column...
=LEFT(A1,3)

and fill down...
 
Upvote 0
Thank you...

This is a real p.i.t.a.
They want to type a word in a cell and only display the first 5 characters.

Ex. Type in Ridiculous (which I think this really is) and only display Ridic

I'm just going to tell them good luck.
I'm going to use the left(a1,5) and be done with it.
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
Extracting text within varying length phrases
Replies
8
Views
901
Peter_SSs
Peter_SSs
D
  • Solved
Sum contents of a cell
Replies
4
Views
277
Rick Rothstein
Rick Rothstein
T
  • Solved
Unwanted hyphen appears in calculated cell
2
Replies
10
Views
297
Alex Blakenburg
A
zookeepertx
  • Solved
Trying to decipher a short bit of code in a macro
Replies
7
Views
362
Alex Blakenburg
A
K
  • Question
Vlookup that copies formatting?
Replies
3
Views
427
Eric W
Eric W

Forum statistics

Threads
1,215,637
Messages
6,125,963
Members
449,276
Latest member
surendra75

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top