Special Character for newline in a cell value

**piyushdeora** · 02-21-2011, 02:27 AM

Hello,

I am integrating the excel in my application.

I have several columns in th eexcel and one of the cell will have values with new line. In excel i can do it by using (Alt+Enter). But when i am programming, in the shared string i tried to use special charaters but could not find one to create new line in the cell.

Could you please help?

For Example:

Name Value Text
Piyush SE I am from Bangalore (Alt+Enter)
I am a programmer

**davesexcel** · 02-21-2011, 05:19 AM

I believe char(10) is the carriage return.

**piyushdeora** · 02-22-2011, 04:42 AM

Hi Dave,

Thank you for your reply.
I do not understand char(10). Is there a special character? Ex '#' or similar?

Thanks

**royUK** · 02-22-2011, 05:05 AM

vbNewLine is easy to remember

Please Login or Register  to view this content.

**piyushdeora** · 02-24-2011, 01:02 AM

Hi Roy,

Unfortunately i am not using VB but ABAP. I tried to concatenate the line feed ( Char 13 ) in the string but did not work.

lv_string = lv_string & 'CHAR10' & 'Newline'.

But it does not create a new line in the cell.