yorkshirelad
Board Regular
- Joined
- Aug 18, 2003
- Messages
- 100
I felt sure there was a standard formula for this one but I can't find it. Any help would be most appreciated.
I have a series of cells that contain a question and an answer. At the end of each question is a colon
).
I need to copy the answers - that is the cell contents that come after the : and then paste the answers in the adjacent cell. I then need to leave just the question in the original cell.
Example
Cell A1 contains - "What's your dogs name: Paddy"
Cell A2 contains - "What's the capital of Italy: Rome"
I need to split that into
Cell A1 - "What's your dogs name:"
Cell B1 - "Paddy"
Cell A2 - "What's the capital of Italy:"
Cell B2 - "Rome"
One final point some of the answers may be blank, so the formula would need to set the calculated cell to also be blank.
Note - The quotes are included just to show cell contents.
Many thanks for any assistance, its much appreciated.
I have a series of cells that contain a question and an answer. At the end of each question is a colon
I need to copy the answers - that is the cell contents that come after the : and then paste the answers in the adjacent cell. I then need to leave just the question in the original cell.
Example
Cell A1 contains - "What's your dogs name: Paddy"
Cell A2 contains - "What's the capital of Italy: Rome"
I need to split that into
Cell A1 - "What's your dogs name:"
Cell B1 - "Paddy"
Cell A2 - "What's the capital of Italy:"
Cell B2 - "Rome"
One final point some of the answers may be blank, so the formula would need to set the calculated cell to also be blank.
Note - The quotes are included just to show cell contents.
Many thanks for any assistance, its much appreciated.