Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I type in 100 a 1 appears, 10000 and 100 appear | Excel Discussion (Misc queries) | |||
how to type a minues figure | New Users to Excel | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Custom Type Charts Problem | Excel Worksheet Functions |