deanlee17
asked on
Manipulating a string
Hi guys,
I have the below text in cell B2..
- This is the first point - This is the second point - This is the third point
Is there a formula I can use in cell A1 to insert text before the second and third dashes (not the first one). Basically i need to upload this csv to a website and cell B2 needs to read:
- This is the first point </br>- This is the second point </br>- This is the third point. So as with the html tags it displays
- This is the first point
- This is the second point
- This is the third point
Many Thanks,
Dean
I have the below text in cell B2..
- This is the first point - This is the second point - This is the third point
Is there a formula I can use in cell A1 to insert text before the second and third dashes (not the first one). Basically i need to upload this csv to a website and cell B2 needs to read:
- This is the first point </br>- This is the second point </br>- This is the third point. So as with the html tags it displays
- This is the first point
- This is the second point
- This is the third point
Many Thanks,
Dean
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER