Firstly, unmerge the cells C2:F2. Then select Cell C2 and use Excel's Text to Columns function to split the data based on commas.
Next use the Replace function to change the "+" to ",".
Firstly, unmerge the cells C2:F2. Then select Cell C2 and use Excel's Text to Columns function to split the data based on commas.
Next use the Replace function to change the "+" to ",".
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Reply With Quote
