how to add numbers to the left or right of the existing numbers?

Y

yalanola

for example:

existing number is 1115, 1116,1117,.... I want add the same number 58744 to
the left of each number, what function should I use?
Thanks
 
M

Max

=58744&A1

Assuming the source numbers are listed in A1 down: 1115, 1116 ...
and we want the result of the concat to be a real number (instead of text)
try this slight revision to Anne's suggestion above
in say, B1: = --(58744&A1)
Copy B1 down
 
R

Roger Govier

Hi

Yet another variation to the 2 answers you have received from Anne and
Max, would be to use a Custom Format.
Format>Cells>Number>Custom 58744#

Now when you enter 1115 in the cell, it will show as 587441115 and it
will increment on the last 4 numbers as you drag the cell down using
fill series.
 
Top