Display only n numbers of characters for long text?

A

Astro

Hi everyone, I would like to find out whether can the following be done?

A1 cell with the information: abcdefghijklmno

For cell B2, I would like only to see n=5 of characters in A1, which will be
abcde?

How to link these 2 cells so that cell B2 will only show me first 5
characters of the long text I keyed in?

Please help....
Thank you.
Best Regards...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Formating bolded text exclusively. 0
Lower-Case Characters 2
Help with an if then scenario 2
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
WORD VBA Search and switch to advanced ... 1
Automatically sending multiple parts of text from one word doc to another - is possible. 0
How can the font and size of (all) citation numbers be altered? 1

Top