Find the first two spaces of the string and put "§" before it

**wali** · 05-20-2010, 05:46 AM

Hello everyone,

which function or formula should I use to put "§" symbol in a string. All the strings are in Column A. The criteris is that "§" should be put once where the two first spaces of the string start. For example:

Column A:
µadfaasdf adfadf adsfkjaf adadsjljfa
µadfaasaas df adfadf adsfkjaf adadsjljfa
µadfaa sdf adfadf adsfkjaf adadsjljfa
µadfa asdf adfadf adsfkjaf adadsjljfa
µadfaa sdf adfadf adsfkjaf adadsjljfa

The result should be:

Column B:
µadfaasdf§ adfadf adsfkjaf adadsjljfa
µadfaasaas§ df adfadf adsfkjaf adadsjljfa
µadfaa§ sdf adfadf adsfkjaf adadsjljfa
µadfa§ asdf adfadf adsfkjaf adadsjljfa
µadfaa§ sdf adfadf adsfkjaf adadsjljfa

Thanks for each assistance in advance.

**DonkeyOte** · 05-20-2010, 05:52 AM

Perhaps:

B1: =SUBSTITUTE(A1," ","§ ",1)

**wali** · 05-20-2010, 06:06 AM

Thanks alot,
i am using german version and I translted it but its not working. I think my translation was not correct. Could you please upload an excel file containing the formula? That will be very kind. When i will open your excel file it will automatically be translated correctly.
thanks