| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing cell numbers but leaving leading zero
I have a list of numbers that have a leading alphabetical character and then
1-3 zeros and then the rest of the numbers. I want to do a find and replace to eliminate the leading alpabetical character, but keep all of the remaining leading zeros. Even when I save the numbers as text, when I do the replace, the leading zeros are gone. suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replacing cell numbers but leaving leading zero
If it is just a single leading character then why not just use a formula like
this... =MID(A2, 2, 256) Where your text string is in A2. -- HTH... Jim Thomlinson "JSPaulk" wrote: I have a list of numbers that have a leading alphabetical character and then 1-3 zeros and then the rest of the numbers. I want to do a find and replace to eliminate the leading alpabetical character, but keep all of the remaining leading zeros. Even when I save the numbers as text, when I do the replace, the leading zeros are gone. suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete all negative numbers leaving only positive numbers | Excel Discussion (Misc queries) | |||
| replacing zeros with blanks but leaving dates alone | Excel Worksheet Functions | |||
| The numbers entered change to symbols when leaving the cell | New Users to Excel | |||
| replacing numbers in a cell | Excel Worksheet Functions | |||
| numbers are being divided by 100 on leaving cell | Excel Discussion (Misc queries) | |||
Linear Mode
