| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
ignore first 2 characters
Is there anyway to format a cell so that it trims off the first 2 characters
of the cell. For example my cell contains a query that shows PR101 or PL101. Is there a way to make it just show 101. For this application the PL and PR don't matter. Am I out of luck on this one or can it be done. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting 3 Text characters from the right | Excel Worksheet Functions | |||
| USING IGNORE BLANKS IN FORMULA | Excel Discussion (Misc queries) | |||
| How do you make some characters in a cell bold and some not? | Excel Discussion (Misc queries) | |||
| if cell starts with characters formula | Excel Discussion (Misc queries) | |||
| How do I ignore newline character/carriage return while importing | Excel Discussion (Misc queries) | |||
Threaded Mode
