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

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
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
870
Peter_SSs
Peter_SSs
D
  • Solved
Sum contents of a cell
Replies
4
Views
265
Rick Rothstein
Rick Rothstein
T
  • Solved
Unwanted hyphen appears in calculated cell
2
Replies
10
Views
266
Alex Blakenburg
A
zookeepertx
  • Solved
Trying to decipher a short bit of code in a macro
Replies
7
Views
344
Alex Blakenburg
A
K
  • Question
Vlookup that copies formatting?
Replies
3
Views
333
Eric W
Eric W

Forum statistics

Threads
1,214,666
Messages
6,120,806
Members
448,990
Latest member
rohitsomani

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