| 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?
|
|
#2
|
|||
|
|||
|
Mid function should do the job sk dalymjl wrote: 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? -- dalymjl |
|
#3
|
|||
|
|||
|
Mid function should do the job sk dalymjl wrote: 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? -- dalymjl |
|
#4
|
|||
|
|||
Quote:
|
| Reply |
| 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 | |||
Linear Mode
