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...
Hi,
with your text list starting in A1, use this in A2 and copy down
=A1&"</br>"
hth
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
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.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks