Parse a String and detect ALT-ENTER?

[KroogerFx]

Heres my problem: I will have a cell that has company names in it and I need to parse each name an then do some work with them but when I started this project I was told each company will be seperated by some number of spaces.
Ex.) |Company1(534553) Company2(3544)|
Right now this is how I'm parsing a line like this:

Please Login or Register  to view this content.

So it will make an array where each block will hold either a company name or a null (because of multiple spaces beside eachother) and I filter that out later.

Now Im being told there is data that is being seperated by, what is essentialy an Enter stroke (Done by pressing Alt-Enter in Excel). This kind of messed up my whole parsing plan.

Firstly how do I detect this Alt-Enter character so I can deal with it, and also is there a way to have code as simple as I have above but will execute under multiple conditions?

What I mean is that i want it to parse into the same array when it hits a SPACE or Alt-Enter. Like using the Split Function but with more than 1 condition?

Thank You

[shg]

Please Login or Register  to view this content.

[KroogerFx]

shg you are a life saver thank you very much

[tarunsoodrnd]

I am showing the data into a datagrid in multiline using <br> tag and its displaying the fine content. like

a
b
c
d

Now I want to export the same content into the execl then its displaying the <br/> tag during excel export. something like this
a<br/>b<br/>c<br/>d<br/>

I tried several option like replace <br/> with "\r\n", "\n" etc but not working.

Can u suggest me the alternative option so that I can implement this export functionality with alt+enter kind of thing.. any suggestion will be of a great help. thanks in advance!

Thank You[/QUOTE]

[Phil_V]

tarunsoodrnd
You need to start your own thread, not hijack someone elses, (which incidently has now be marked as solved, so no-one will see your question anyway!)