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

Michael Ibounig
Occasional Visitor

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 !
GreetingsExcel Sheet.PNGSearch and Replace | Rows with " text "



Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies