Excel 2007 : How to add text in column before other text

**dalford** · 05-17-2012, 12:53 PM

I have 16,436 rows and i need to add "item:" to the text already in the column. So for example. I have different image names in each row like feather.png and i need to make it like this "item:feather.png" for all 16,436 rows. Some help would be greatly appreciated. I had actually found the answer on how to do this on another forum and few days back, but the site is not working now and Google blocks it saying that it could be harmful to my PC. The maco that i found was actually to add something to the end of a column and i was able to modify it to put it in the front instead.

If at all possible i would rather a macro i can run vs. some short formula that i will have to put in an empty column, copy paste etc.

Team Web USA
Web Design Company

**SCLai** · 05-17-2012, 09:46 PM

Originally Posted by dalford

If at all possible i would rather a macro i can run vs. some short formula that i will have to put in an empty column, copy paste etc.

Sorry... I don't really know VBA, but if you are in a hurry for a solution, I do have one of those that requires copy-and-paste...

1.) If your data is in Col A, key item: into any cell:
E.g. into C1
2.) In Col B, use: =CONCATENATE($C$1,A1)
Apply this to the whole of Col B.
3.) Select whole of Col B, Copy
4a.) Select Col A, Right Click > Paste Special > Values
4b.) OR Select Col B, Right Click > Paste Special > Values, check if everything is correct, delect Col A.

Hope this will help if you are in a hurry for a soulution...

SC

Excel 2007 : How to add text in column before other text

LinkBack

Thread Tools

Rate This Thread

Display

How to add text in column before other text

Re: How to add text in column before other text

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions