| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMULA TO MINUS TEXT CHARACTERS
=RIGHT(A1,LEN(A1)-3)
-- Gary''s Student - gsnu2007c |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMULA TO MINUS TEXT CHARACTERS
K,
Lots of ways to do this: Take away the first 3 characters. =MID(A1,4,LEN(A1)) =RIGHT(A1,LEN(A1)-3) Take away the last three characters. =MID(A1,1,LEN(A1)-1) =LEFT(A1,LEN(A1)-3) Take away first and last 3 =MID(A1,4,LEN(A1)-6) =RIGHT(LEFT(A1,LEN(A1)-3),LEN(LEFT(A1,LEN(A1)-3))-3) HTH, Bernie MS Excel MVP "K" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
FORMULA TO MINUS TEXT CHARACTERS
On 4 Feb, 16:07, "Bernie Deitrick" <deitbe @ consumer dot org wrote:
K, Lots of ways to do this: Take away the first 3 characters. =MID(A1,4,LEN(A1)) =RIGHT(A1,LEN(A1)-3) Take away the last three characters. =MID(A1,1,LEN(A1)-1) =LEFT(A1,LEN(A1)-3) Take away first and last 3 =MID(A1,4,LEN(A1)-6) =RIGHT(LEFT(A1,LEN(A1)-3),LEN(LEFT(A1,LEN(A1)-3))-3) HTH, Bernie MS Excel MVP "K" wrote in message ... 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- Hide quoted text - - Show quoted text - Thanks bernie |
| Reply |
| 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)
Linear Mode
