replace a number in a sentence every time it is dragged

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

euro.stat 1434,41051,country=s
I want to replace 41051 with other 5 digit numbers every time i drag it in
Excel.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS word Find and Replace using Regex - Help required 0
using the =page! feature to transpose a row to column 0
Excel Drag autofill only part of formula 3
Show me your highest mileage HDD? 0
Function in Excel to count and list number of entries of text valuesin a row. 2
Copy Paste Financial Years 3
Find and Replace wildcards 2
Why Excel Does not increment by 2 or 3, odd/even numbers? 6

Back
Top