| [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? |
|
 CudniLa Merma - VigiladoPremium,MVM
join:2003-12-20
Someshire
kudos:13 | the simplest approach
in next column (B) enter a formula
="abcd"&"A2"
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 |
|
psglaspieDocscott
join:2003-12-19
Mount Pleasant, TX | 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 |
|
psglaspieDocscott
join:2003-12-19
Mount Pleasant, 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 |
|
|
|
| Thanks for the replies  |
|
