alt+enter character

[neveu]

hi,
I am getting some data from another program and dowload them into SAP.
there is a problem with the output of this data. the problem is that i need to separate the information from this cell and the separating character is that question mark sign which i think represents the ALT+Enter used to write information on different rows in the same cell in excel.
however i cannot copy paste this sign in excel.
could someone offer some suggestion on how to proceed in this issue?

 

[sulakvea]

would something like this help? if its an issue with alt+enter, it should solve it (works on 2003)

=LEFT(T2,FIND(CHAR(10),T2)-1)

 

[neveu]

hi,
your formula works great. but i need to extract the data in the cell not just the alt+enter character.

 

[sulakvea]

it does extract everything that sits LEFT of the alt+enter

 

[neveu]

hi,
this is what i get with the formula

for example, for the information in T2, i will need to get the information like in cells AO, AP , AQ