' 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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies