Entering digits in a cell with numbers already inside cell

[pjamorton]

Hi All,

I have a question as to whether there is a fast and easy way to enter
some digits into a cell that already has digits. For example, I have
a cell with the numbers 123456 and I would like to add 149 to the
beginning without having to manually go into the cell and add 149 to
it, as I have a LOT of cells to do this to. At the end, the result
should be 149123456. Any ideas?? I appreciate any help. Thank you in
advance!!

Jen

 

[Spiky]

Hi All,

I have a question as to whether there is a fast and easy way to enter
some digits into a cell that already has digits. For example, I have
a cell with the numbers 123456 and I would like to add 149 to the
beginning without having to manually go into the cell and add 149 to
it, as I have a LOT of cells to do this to. At the end, the result
should be 149123456. Any ideas?? I appreciate any help. Thank you in
advance!!

Jen

If it is always "149" that will be added, use Concatenate in another
column. Then copy the result back to your original column, Paste
Values only. Then delete the extra column.
=149&A1 or =CONCATENATE(149,A1)

If you have different things to add to each cell, use 2 columns. One
to enter the new digits and the 2nd for the Concatenate. Then do the
copying.

Or, for easier data entry, you can press F2 and then Home to get to
the beginning of a cell. But this will take longer.

 

[FSt1]

hi
you could add a helper column next to your column of numbers then in the
helper column, put this formula.....
assuming the number column is column A....
=149 & A2
copy down the helper column to desired end.
then copy the helper column and paste special values
delete column A(or archive)

Regards
FSt1

 

[Peo Sjoblom]

If the OP wants numbers instead of text he/she might want to add something
to
keep it numerical


=--(149&A1)



--


Regards,


Peo Sjoblom

 

[Rick Rothstein \(MVP - VB\)]

You could select the cells you want to add the 149 in front of and run this
macro...

Sub Concatenate149()
Dim C As Range
For Each C In Selection
C.Value = "149" & C.Value
Next
End Sub

Rick