Scripting

  • Thread starter Thread starter Stefan
  • Start date Start date
S

Stefan

Hi,

I looking for a script that will do this:

Inputdata: 4702168703

Outputdata: 1947

Function: I will import data with 10 digits, I will erase all digits after
the first to and replace it with 19 in front of the first two.

If this i possible to without scripting I prefer that solution.

Looking forward to creative and functional solutions

//Stefan C
 
Hi Stefan,

Try this, if you input your 10 digits in Cell A1 put this in your output
cell =19&LEFT(A1,2)
--
Regards
Warren
Excel Novice

If this helps please click the Yes button.
 
EXTEXT is used in some of the Scandinavian versions of Excel.
The English equivalent would be
=19&MID(A1,1,2)
but it's easier to use LEFT as Warren suggested.
 
Back
Top