Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
Is there a possibility to replace characters in cell? For example i want to change particular characters like Ą -> A, Ć -> C, Ę->E, Ń -> N etc (i was looking for function to do this but google only shows me a threads with remove instead of replace)
Thanks for help
Wojtek
Hi
What you would need to do in that case is
Replace(Replace('aąbć','ą','a'), 'ć','c')
If the number of replacements is not that big then this nesting of the Replace function should work fine.
Regards
Adrian
Hi
There is a Replace() function below is the link to help page
Regards
Adrian
Yes, function replace could be useful in this case but can i replace 2 or more characters?
for example if i have string: aąbć and want to change it to: aabc? Replace('aąbć','ą',a' & 'ć','c') dont work
Hi
What you would need to do in that case is
Replace(Replace('aąbć','ą','a'), 'ć','c')
If the number of replacements is not that big then this nesting of the Replace function should work fine.
Regards
Adrian
I have to replace 7 characters but i will try this option.
Thank you very much!