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! |
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! |
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! |
All times are GMT +1. The time now is 03:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com