Type the no.1 after third Numeral
 

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.

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" wrote:

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.

Thanks very much excellent hours saved.

Cheers

"Barb R." wrote:

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" wrote:

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.