| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
replace a number in a sentence every time it is dragged
euro.stat 1434,41051,country=s
I want to replace 41051 with other 5 digit numbers every time i drag it in Excel. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
replace a number in a sentence every time it is dragged
One try ..
Source data as posted assumed representative, and running in A1 down, with replacement numbers listed in B1 down Put in C1: =LEFT(A1,LEN(A1)-SEARCH(",",A1))&TEXT(B1,"00000")&RIGHT(A1,LEN(A1)-SEARCH(",",A1,SEARCH(",",A1)+1)+1) Copy down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "SushilNayal" wrote: euro.stat 1434,41051,country=s I want to replace 41051 with other 5 digit numbers every time i drag it in Excel. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locking Clolumn Color So It Won't Get Dragged Away | Excel Discussion (Misc queries) | |||
| how to globally replace two values at the same time in Excel | Excel Discussion (Misc queries) | |||
| Formula not changing when Dragged!!!! | Excel Discussion (Misc queries) | |||
| why does excel replace letter m with a 1 every time | Excel Discussion (Misc queries) | |||
| Indirect reference to another sheet that can be dragged | Excel Worksheet Functions | |||
Linear Mode
