' if(A1="*"; "*"; "") ' *=Text | Function that puts text into Cell | put found text in Cell X

Copper Contributor

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 "Search and Replace | Rows with " text "

 

 

0 Replies