Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |