Skip to main content

Excel : Join strings from two cells

To concatenate two cells to one cell and have them in two different line use the below technique.

Lets say A1 has This is line one
B1 has This is line two






To have C1 as  This is line one This is line two  give =CONCATENATE(A1," ",B1)

To have C1 as This is line one
                        This is line two
 give =A1&CHAR(10)&B1


Labels:

Comments

Post a Comment

Popular posts from this blog

C programing : File

/* Program to take lines 1,4,7,10.... from a text file and to write into a new file. It is written in c with platform devcpp*/ /* eg:- input file -> ab.txt contain 1 lady gaga sdrgrg ergerg 2 oraph winfrey dfgdr dfgdf . output file neww.txt 1 lady gaga 2 oraph winfrey . . */ #include #include #include using namespace std; main() { char c; FILE *fp1,*fp2; if(fp1=fopen("e:\\ab.txt","r")) { cout<<"\n opened fp1"; } else { cout<<"\n failed fp1"; } if( fp2=fopen("e:\\neww.txt","w") ) { cout<<"\n opened fp2"; } else { cout<<"\n failed fp2"; } while(!feof(fp1)) { c=getc(fp1); while(c!='\n') { putc(c,fp2); c=getc(fp1); } putc('\n',fp2); c=getc(fp1); while(c!='\n') { c=getc(fp1); } c=getc(fp1); while(c!='\n') { c=getc(fp1); } } cout<<"\n End"; getch(); return 0; }
1 comment
Read more

OpenCV installation with Visual Studio 2010

Hi all.I will show you how to install OpenCV library in windows with Visual Studio 2010 to use with Visual C++ Here I am show to install OpenCV Ver 2.2. 1. Download the OpenCV from source forge     The link is : http://sourceforge.net/projects/opencvlibrary/files/opencv-win/ 2. Install the OpenCV to any drive.I have installed as C:\OpenCV2.2 3. Next open Visual Studio 2010.Select New>Project 4. Select Win32 Console Application from Visual C++ popup. 5. Give the project a name and press OK . I gave as 'helloworld' 6. Click Finish to continue.You can see a new file has opened where you can type your code. 7. Next select Project> <your project name> Properties . 8. Go to VC++ Directories and select Include Directories.There add the two links to that     a) C:\OpenCV2.2\include     b) C:\OpenCV2.2\include\opencv 9. Next Go to Library Directories and add the following link     a) C:\OpenCV2.2\lib 10. Now Go to Linker option from the left
1 comment
Read more

Install sublime editor

Hi. Sublime editor is a light weight editor and very helpful for developers to write code.It will highlight the code in colors for easy readability. Sublime editor 3 is the latest one available as of now . The below link shows how to install sublime editor in CentOS . http://software-engineer.gatsbylee.com/how-to-install-sublime-3-on-centos-7-rhel-7/ To know about you system OS is 32 bit or 64 bit , use the below command. >uname -a 
Post a Comment
Read more