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.


"Stefan" wrote:

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

This will do the job:

=19&EXTEXT(A1;1;2)

Thanks for the with 19&

"Warren Easton" wrote:

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.


"Stefan" wrote:

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

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.
--
David Biddulph

"Stefan" wrote in message
...
This will do the job:

=19&EXTEXT(A1;1;2)

Thanks for the with 19&

"Warren Easton" wrote:

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.


"Stefan" wrote:

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