(Msg. 1) Posted: Mon Aug 18, 2008 1:56 pm
Post subject: Entering digits in a cell with numbers already inside cell Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
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!!
(Msg. 2) Posted: Mon Aug 18, 2008 2:05 pm
Post subject: Re: Entering digits in a cell with numbers already inside cell [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Aug 18, 3:56 pm, pjamor... RemoveThis @hotmail.com wrote:
> 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.
(Msg. 3) Posted: Mon Aug 18, 2008 2:10 pm
Post subject: RE: Entering digits in a cell with numbers already inside cell [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
"pjamorton@hotmail.com" wrote:
> 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
>
(Msg. 4) Posted: Mon Aug 18, 2008 2:17 pm
Post subject: Re: Entering digits in a cell with numbers already inside cell [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
If the OP wants numbers instead of text he/she might want to add something
to
keep it numerical
=--(149&A1)
--
Regards,
Peo Sjoblom
"Spiky" <jeff.thorstad DeleteThis @gmail.com> wrote in message
news:f3acad2f-ee49-4f50-8871-0a8f5c104d8f@p25g2000hsf.googlegroups.com...
> On Aug 18, 3:56 pm, pjamor... DeleteThis @hotmail.com wrote:
>> 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.
(Msg. 5) Posted: Mon Aug 18, 2008 5:34 pm
Post subject: Re: Entering digits in a cell with numbers already inside cell [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
<pjamorton.DeleteThis@hotmail.com> wrote in message
news:c6c2a7fd-4808-47d6-94aa-0a78d4f728a1@a3g2000prm.googlegroups.com...
> 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
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office