| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
removing zeroes almost perfect
Hi I am using this to convert BHQ0009540 to C9540
=CONCATENATE("C",MID(RIGHT(B2,7),SEARCH(LEFT(SUBST ITUTE(RIGHT(B2,7),"0",""), 1),RIGHT(B2,7)),25)) the issue is sometimes i need a leading 0 like converting LPB0000385 to C0385. using the above I get C385. I am at a loss. any ideas? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how many perfect score | Excel Discussion (Misc queries) | |||
| How to fit each cell into a perfect square? | Excel Discussion (Misc queries) | |||
| Making the perfect sort. | Excel Discussion (Misc queries) | |||
| searching for my perfect algorithm.... | Excel Discussion (Misc queries) | |||
| looking for my perfect algorithm | Excel Discussion (Misc queries) | |||
Threaded Mode
