how to add text in beginning/end of each row in excel

[ASP__DEVELOPER]

In my excel file it's something like this

Name Specification

Product1 17"Screen
Product1 128 RAM
Product2 256 RAM
Product2 Screen Protector
Product1 40 GB Hard Disk
Product1 121 Keys
Product1 Intel Mouse
Product2 15"Screen
Product2 Charger
Product2 Headphones
Product1 15"Screen
Product2 256 RAM
Product3 Screen Protector
Product4 Charger
Product5 Headphones

......and so on....for 1000's of products....

I want to add "</br>" in second column at the end of each line/row/para/cell or whatever you call it

something like this

In my excel file it's something like this

Name Specification

Product1 17"Screen</br>
Product1 128 RAM</br>
Product2 256 RAM</br>
Product2 Screen Protector</br>


PLEASE HELP...ITS REALLY URGENT...

[teylyn]

Hi,

with your text list starting in A1, use this in A2 and copy down

=A1&"</br>"

hth

[DonkeyOte]

Given you've asked the above in your other post:

http://www.excelforum.com/excel-misc...st-column.html

this thread is considered a duplicate and as such is closed.