| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FORMULA TO MINUS TEXT CHARACTERS
Hi, i have data on my spreadsheet please see below
ME54001528 ME54001961 ME54002025 ME54002160 ME54001207 ME5EE120 ME5EE200 ME54000441 ME51831103 ME54002119 ME51842129 ME54001784 ME54001212 ME51842123 ME54001952 ME54002086 ME54001350 i want formula which should minus first three text characters or you can say take away first three text digits and put rest of the text in cell. I know the formulas of =LEFT and =RIGHT but i dont know how to minus first three or last three text characters whith these formulas. Is there anybody can help me |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to handle a minus sign "-" as text not as part of a formula? | Excel Discussion (Misc queries) | |||
| formula to truncate text characters | Excel Discussion (Misc queries) | |||
| Formula to Pick Out Characters within a Text String | Excel Worksheet Functions | |||
| CHANGE TRAILING MINUS TO BRACKETS OR PRECEEDING MINUS | Excel Discussion (Misc queries) | |||
| Remove characters from a text string using a formula | Excel Discussion (Misc queries) | |||
![K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
