| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract some info from a string
I'm sure this is easy for you guys!
How would you extract some info from a string. I have some codes and would like to strip the first two characters off the string. Here is the example: What I have: NM055 What I need: 055 Any help would be appreciated! Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extract some info from a string
Assuming that the first value is in A1 you could use the following formula:
=RIGHT(A1,LEN(A1)-2) Or if the lenght is always the same you can use: =RIGHT(A1,3) -- Kevin Backmann "Mathew" wrote: I'm sure this is easy for you guys! How would you extract some info from a string. I have some codes and would like to strip the first two characters off the string. Here is the example: What I have: NM055 What I need: 055 Any help would be appreciated! Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extract some info from a string
Kevin: thanks it worked great!
"Kevin B" wrote: Assuming that the first value is in A1 you could use the following formula: =RIGHT(A1,LEN(A1)-2) Or if the lenght is always the same you can use: =RIGHT(A1,3) -- Kevin Backmann "Mathew" wrote: I'm sure this is easy for you guys! How would you extract some info from a string. I have some codes and would like to strip the first two characters off the string. Here is the example: What I have: NM055 What I need: 055 Any help would be appreciated! Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract " " space from middle of a string | Excel Worksheet Functions | |||
| Extract from string | Excel Discussion (Misc queries) | |||
| Extract number from text/number string.. | Excel Discussion (Misc queries) | |||
| EXTRACT NUMBERS FROM TEXT STRING | Excel Worksheet Functions | |||
| Extract hyperlink string from excel cell | Links and Linking in Excel | |||
Linear Mode
