| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Return first 'n' characters
I have a spreadsheet with a column containing a reference number which consists of 7 digits followed by a letter (e.g. 1234567P). How do I get Excel to write just the 7 digits to a new column?
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
| How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions | |||
| How to return # characters based on 2nd instance of value | Excel Worksheet Functions | |||
| if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
| Find/Replace carriage return & line feed characters in Excel. | Excel Worksheet Functions | |||
Threaded Mode
