[R] ascii or regex code for alt-enter for Excel

Duncan Murdoch murdoch.duncan at gmail.com
Wed Oct 20 19:29:25 CEST 2010


On 20/10/2010 1:04 PM, Mark Kimpel wrote:
> I need to write a table that can be opened in Excel or OpenOffice such that
> there are newlines embedded within cells.
>
> After much Googling and futzing, I can't figure out how to do this. The way
> to do this within Excel is alt-Enter and I've tried '/n', '/n/r', '/r/n' per
> some web suggestions without luck.

You may need to ask an Excel expert or MS tech support.  What character 
is Excel looking for?

(Or it is possible that you have what you need, but used forward slashes 
when you should have used backslashes.  The newline character is \n, not 
/n, in R.)

Duncan Murdoch

> Anybody know what character or ASCII code to use for this?
>
> Thanks,
>
> Mark
>
> Mark W. Kimpel MD  ** Neuroinformatics ** Dept. of Psychiatry
> Indiana University School of Medicine
>
> 15032 Hunter Court, Westfield, IN  46074
>
> (317) 490-5129 Work,&  Mobile&  VoiceMail
> (317) 399-1219 Skype No Voicemail please
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.



More information about the R-help mailing list