Page 1 of 1

[Solved] Add text to the beginning of every cell

Posted: Mon Jan 25, 2010 8:19 am
by gcz
Hi,

How can I add the same text to the beginning of multiple cells under one column (A1:A400)? Currently I have websites listed in simple address (i.e example.net) and I need to add "http://" to the beginning of all the addresses. There's a few hundred of them so adding the text manually is a bit too labourous.

Thanks in advance for any help!

Re: Adding text to the beginning of every cell?

Posted: Mon Jan 25, 2010 9:00 am
by vasa1
gcz wrote:Hi,

How can I add the same text to the beginning of multiple cells under one column (A1:A400)? Currently I have websites listed in simple address (i.e example.net) and I need to add "http://" to the beginning of all the addresses. There's a few hundred of them so adding the text manually is a bit too labourous.

Thanks in advance for any help!
First, insert an additional column (alt, i, l) to the left of column A. Your stuff is now in column B.
Then, in the first cell (A1) type what you want to add at the beginning: in this case, http://. Then copy and paste down as far as you have content in column B. (added in edit :oops: )

Next go to cell C1 and type =concatenate(A1; B1) and hit enter. You should see what you want in cell C1.
Then copy the contents of C1 and paste down as far as you need.

If you are finished, you can select column C, copy, and then paste special: here uncheck paste all, but check numbers and uncheck formulas and hit enter. Then you can delete columns A and B.

Re: Adding text to the beginning of every cell?

Posted: Mon Jan 25, 2010 7:00 pm
by JohnV
Or select the cells involved and use Find & Replace.
Search = (.*)
Replace = http://$1
Click More Options, check "Current selection only" and "Regular expressions". Do Replace All.

Re: Adding text to the beginning of every cell?

Posted: Tue Jan 26, 2010 1:59 pm
by gcz
Thanks a lot, both methods work great!

Re: [Solved] Adding text to the beginning of every cell?

Posted: Fri Aug 02, 2013 8:33 am
by tapas
Thanks a lot just registered to say thanks. Both method are good and the 2nd method is best.

Re: [Solved] Adding text to the beginning of every cell?

Posted: Fri Mar 24, 2023 3:41 pm
by j1ceasar
thanks - even though this was an OLD reply - it still works ! :bravo: :bravo: :bravo: