Need help in Find and replace

[uvaidya]

Dear All
I have a column "B" containing the email address of the recepients.
I want to concatenate all those email ids into one, with a ";" between them. so that I can add the list to my To address.
Now How do I do a Find and replace here.
I need to say, find the beginning of every word, and add a ";" to it.
For e.g
Column B
[email protected]
[email protected]
[email protected]

should become like this after my find and replace
Column B
;[email protected]
;[email protected]
;[email protected]

Thanks in advance for your help

[Bishonen]

Please Login or Register  to view this content.

[uvaidya]

Thanks very much.
But is there any way I can do this from the Excel sheet. That is the "Find what" field of the pop up window, will take any wild card character that specifies the beginning of the word?

[Tsjallie]

See this article: http://excel.tips.net/T003303_Wildca...With_Text.html
But you can also construct the desired string with the formula =";"&Bx in some extra column. That would give you ";[email protected]" in the extra column which you can then use for your purpose.

[Fredy.Antony]

Done.xlsx

Check the Column B Formula

Fredy

[uvaidya]

thank you. that works.

[uvaidya]

Thanks for all the reply.
In MS Word, you can specify the beginning of the word with'<'. I wanted to check if there is a similar option available in Excel as well.