Type the no.1 after third Numeral

[Steved]

Hello from Steved

Please I would like to do the below

813, 844, 256, 358, 437, 937 how would one go about adding 1 to end as set
out below please

8131, 8441, 2561, 3581, 4371, 9371 ie replace 813 with 8131 as an example.

ps I've several hundred to do

Thankyou.

 

[Barb R.]

I assume you want the result as a number. If your # is in A1, enter this to
get a numeric response. If you only need the data as text, use only the
info between the parens.

=VALUE(A1&"1")

 

[Steved]

Thanks very much excellent hours saved.

Cheers

I assume you want the result as a number. If your # is in A1, enter this to
get a numeric response. If you only need the data as text, use only the
info between the parens.

=VALUE(A1&"1")