Hi,
Is there a way to automate the below process?
Turn a text wrapped cell:
"Valuation Risk,
Counterparty Credit Risk
Concentration Risk
Equity Risk
Medium Companies Risk"
In to a non text wrapped cell and in the below format:
Valuation Risk, Counterparty Credit Risk, Concentration Risk, Fixed Income Risk, Equity Risk, Medium Companies Risk
Many thanks,
Brandon
Hi bdb1 & welcome to the forum,
You can simply follow the below steps
- Select the column where your data is in
- Press Ctrl+H to pop-up the "Find & Replace" box
- In the "Find What" click Ctrl+J
- In the "Replace With" enter , (comma followed by a space)
Or if you need VBA ...
Please Login or Register to view this content.
If I was able to help, you can thank me by clicking the * Add Reputation under my user name
Wouldn't that give two commas after Valuation Risk ?
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks