View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\)[_1131_] Rick Rothstein \(MVP - VB\)[_1131_] is offline
external usenet poster
 
Posts: 1
Default Entering digits in a cell with numbers already inside cell

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

wrote in message
...
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