Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
On Sun, 16 Nov 2008 22:40:04 -0500, "Rick Rothstein"
wrote: I think you will need to expand this formula to handle product codes that begin with one or more A's (they turn into leading zeroes which are dropped because a number is being returned). Consider this instead... Nice pickup and solution. --ron |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
extract characters from filename | Excel Worksheet Functions | |||
Can I assign keyboard shortcuts for special characters in Excel 20 | Excel Discussion (Misc queries) | |||
Extract Numerics only | Excel Discussion (Misc queries) | |||
Extract the first few characters | Excel Worksheet Functions | |||
HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions |