senote
join:2004-02-02
| [Excel] Office Excel help needed
I have a large Access database which I have exported to Excel, I want to add a line of text to a row of cells. So for example if we have efg I want to add abcd to the start to make abcdefg.
Is there an easy way to do it other than pasting it hundreds of times? |
|
Cudni
La Merma - Vigilado
Premium,MVM
join:2003-12-20
Someshire
| the simplest approach
in next column (B) enter a formula
where a2 contains efg
and copy down the formula
"..
click and hold on the handle of the cell with the formula, and drag.."
Cudni
--
"Mercifully, he hit him with the soft end of the pistol."
Help yourself so God can help you.
Microsoft MVP, 2006 - 2008 |
|
psglaspie
Docscott
join:2003-12-19
Cooper, TX
 ·NEATO
| reply to senote
If I understand what you want to do, you could use the concatenate function. Just insert a new column and use concatenate to add "abcd" to the contents of the existing column. Then you could need to "copy" and "paste special...values" into a third column. Delete the original column and your "concatenate" column.
--
Motorola Canopy 900MHz|Linksys/DD.WRT-Vista/XPPro/Ubuntu |
|
psglaspie
Docscott
join:2003-12-19
Cooper, TX | reply to senote
Same solution, though Cudni explained it better. Copy, paste special, delete old columns only necessary if you want to get rid of the original columns.
--
Motorola Canopy 900MHz|Linksys/DD.WRT-Vista/XPPro/Ubuntu |
|
senote
join:2004-02-02 | Thanks for the replies  |
|
