| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display only n numbers of characters for long text?
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... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Display only n numbers of characters for long text?
Hi,
Please read up on the LEFT() function in Excel's Help menu -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Astro" wrote in message ... 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... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting certain characters from a long string | Excel Worksheet Functions | |||
| Validation - Precede with LR and between 6 and 9 characters long. | Excel Discussion (Misc queries) | |||
| Display text 1024 characters in a cell | Excel Worksheet Functions | |||
| How do you convert numbers as "text" to values for a long column . | Excel Discussion (Misc queries) | |||
| Display numbers only, no text formula | Excel Worksheet Functions | |||
Linear Mode
