alt+enter character

neveu

Board Regular
Joined
Jan 27, 2009
Messages
225
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?
34113993.png
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

sulakvea

Well-known Member
Joined
Jul 2, 2008
Messages
994
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

Board Regular
Joined
Jan 27, 2009
Messages
225
hi,
your formula works great. but i need to extract the data in the cell not just the alt+enter character.
 

sulakvea

Well-known Member
Joined
Jul 2, 2008
Messages
994
it does extract everything that sits LEFT of the alt+enter
 

neveu

Board Regular
Joined
Jan 27, 2009
Messages
225
hi,
this is what i get with the formula
52991250.png


for example, for the information in T2, i will need to get the information like in cells AO, AP , AQ
23526047.png
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,985
Messages
5,767,443
Members
425,414
Latest member
chwein

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top