Need formula to add + sign between characters in multiple cells

[zarab]

Hello
I have a list of names in excel where I need to add + sign to after the first, second, and last name is there a formula to do that
I tried to use text to column feature but it takes sometime any one can help

[Debraj Roy]

Do you want something like this..

="+" &SUBSTITUTE(A1," "," +")

[zarab]

Thanks this works but how can i delete the first plus I need to insert it after the first name and not before it, the rest of the equation is working but i need to remove the plus frm the beginning

[Debraj Roy]

Yes you can..

=SUBSTITUTE(A1," "," +")

[zarab]

thx worked