Forum Discussion
Michael Ibounig
Nov 04, 2017Copper Contributor
' if(A1="*"; "*"; "") ' *=Text | Function that puts text into Cell | put found text in Cell X
Example Cell (A2)
spotify:track:6xez71zpAqQ6N5i8E1jHlD,"Carmina Burana: O Fortuna","Carl Orff, Cleveland Orchestra, Michael Tilson Thomas","Orff: Carmina
I want to write a function that posts a specific text from another cell into one.
e.g. ' if(A2="*"; "*"; "") ' wanted Result -> "Carmina Burana: O Fortuna" (...)
I wrote "*" because that works in Search and Replace (finds ' "texta" ', ' "textb" ',..)
But I found nothing in Search and Replace (Excel 2013) to say put found text in Cell X
Would be great if you could help me !
GreetingsSearch and Replace | Rows with " text "
No RepliesBe the first to reply