| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula for first three characters
In worksheet cell R24 (merged cells R24:T24), is a number in the following format: 1.1.3; 2.3.1; 4.3.2; etc
In cell N22 (merged cells N22:O22) I want to put the first three characters of the R24 entry. In the above examples, the response would be: 1.1, or 2.3, or 4.3 What would the formula be Thanks Phi |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I use only 2 characters in a field in a formula | Excel Worksheet Functions | |||
| Too many characters in formula? | Excel Worksheet Functions | |||
| FIND CHARACTERS within a FORMULA | Excel Discussion (Misc queries) | |||
| Number of Characters for a formula | Excel Discussion (Misc queries) | |||
| too many characters in formula | Excel Worksheet Functions | |||
![Phil Hageman[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
