| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with a simple formula
Thanks soooooo much.
"Toppers" wrote: with value in A1: in B1: =LEFT(A1,9) & "1" & RIGHT(A1,2) &"41" Copy down HTH "Byron720" wrote: Correct: I want to replace the last two digits (01) with 10141. For example: 3175AAA0101 ----- 3175AAA0110141 3175XXX0806 ----- 3175XXX0810641 i want to add the number "41" at the end and the number "1" in between the last four numbers "Toppers" wrote: 3175AAA01 01 3175AAA01 10141 What exactly to change .... 01 to 10141? or 3175AAA01 01 to 3175AAA0101000? "Byron720" wrote: I have a list of numbers like this 3175AAA0101. I need to convert them all to this format: 3175AAA0110141. How do I do it? Byron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| simple formula | Excel Worksheet Functions | |||
| A formula, probably quite simple..... | Excel Worksheet Functions | |||
| simple formula? | Excel Discussion (Misc queries) | |||
| Help - Simple Formula ! | Excel Discussion (Misc queries) | |||
| Need a simple formula please | Excel Worksheet Functions | |||
Hybrid Mode
