Mark McInerney
Active Member
- Joined
- Apr 4, 2012
- Messages
- 262
- Office Version
- 365
- Platform
- Windows
Hi Folks,
I have a range of data A1:D1 - the values of the cells are dynamically linked to other cells.
For this example - they are A1 = "0", B1 = "0", C1 = "Cake" and D1 = "Nice"
I need to retrieve only the text strings and place something that delimits them as well - I want the output to be Cake / Nice
Another example A1 = "Karen", B1 = "0", C1 = "0" and D1 = "Wall" - I want the output to be Karen / Wall
Is this possible?
Many Thanks for taking a look - appreciated - Mark.
I have a range of data A1:D1 - the values of the cells are dynamically linked to other cells.
For this example - they are A1 = "0", B1 = "0", C1 = "Cake" and D1 = "Nice"
I need to retrieve only the text strings and place something that delimits them as well - I want the output to be Cake / Nice
Another example A1 = "Karen", B1 = "0", C1 = "0" and D1 = "Wall" - I want the output to be Karen / Wall
Is this possible?
Many Thanks for taking a look - appreciated - Mark.