Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel for Dummies Question!: How do I insert additional data into an
existing cell following my existing data and NOT replacing it? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
There are several different ways:
1. If you have text in a cell and want to append stuff to it, then do it in the formula bar. Click at the end of the old material in the formula bar and type the additional stuff in. 2. If you want to append stuff from another cell then, use concatinate =A1 & B1 and copy back inbto A1. 3. If you have numbers that you want to label, say "miles", then use custom formatting -- Gary's Student "CSJ545" wrote: Excel for Dummies Question!: How do I insert additional data into an existing cell following my existing data and NOT replacing it? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I like to edit in the formula bar. I just use the mouse to select the cell,
then click at the end of the value in the formulabar. Selecting the cell, then hitting F2 would be equivalent. CSJ545 wrote: Excel for Dummies Question!: How do I insert additional data into an existing cell following my existing data and NOT replacing it? -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank You! F2 is exactly what I was looking for! I'm a hands-on keyboard
user and don't like to stop and use my mouse if I don't have to. You've saved me a lot of time and frustration! Thanks Again "Dave Peterson" wrote: I like to edit in the formula bar. I just use the mouse to select the cell, then click at the end of the value in the formulabar. Selecting the cell, then hitting F2 would be equivalent. CSJ545 wrote: Excel for Dummies Question!: How do I insert additional data into an existing cell following my existing data and NOT replacing it? -- Dave Peterson |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks so much for your reply. The F2 key is actually what I was looking for.
"Gary''s Student" wrote: There are several different ways: 1. If you have text in a cell and want to append stuff to it, then do it in the formula bar. Click at the end of the old material in the formula bar and type the additional stuff in. 2. If you want to append stuff from another cell then, use concatinate =A1 & B1 and copy back inbto A1. 3. If you have numbers that you want to label, say "miles", then use custom formatting -- Gary's Student "CSJ545" wrote: Excel for Dummies Question!: How do I insert additional data into an existing cell following my existing data and NOT replacing it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
if data in one cell, then date in adjacent cell | Excel Worksheet Functions | |||
data in cell | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Splitting Data in a Cell | Excel Worksheet Functions | |||
Multiple worksheet queries | Excel Worksheet Functions |