TechArena Community

TechArena Community (http://forums.techarena.in/)
-   Software Development (http://forums.techarena.in/software-development/)
-   -   Add contents of one cell to another (http://forums.techarena.in/software-development/1265510.htm)

HiSpeed 31-10-2009 05:25 PM

Add contents of one cell to another
 
I created an excel spreadsheet, one sheet because I do not think I need more. I like:

- Write text (name of study) in a cell
- Write text (password) to another cell
- Then in other cells, write text that is fixed by incrementing my 2 other cells in various locations.

Example:

Cell A1 = study1
Cell A2 = password
Cell A3 = config PFADMIN CDD_Cell CSD A1 Unit A1 Unit A2 enable
Cell A4 = config PFADMIN CDD_Cell CSD A1 Unit A1 Unit A2 active

This is to get into the cell:

A3 = config PFADMIN CSD CDD_study1 study1 enable password
A4 = config PFADMIN CSD CDD_study1 study1 password active

I do not want that generates calculations in Excel, I just want my cell A3 completed correctly to make a simple copy and paste to use it elsewhere (in DOS )....

Is there anyone who can suggest me how to add contents of one cell to another?

kelfro 31-10-2009 05:32 PM

Re: Add contents of one cell to another
 
Look if MID () does not solve your problem. Otherwise I see no other method that the code CELL ("contents", A1)

tries to edit
A1 => name
A2 => password
A3 => config PFADMIN CSD CDD_
A4 => enable password
A5 => password active

Form A6
= CELL ("contents", A3) & CELL ("contents", A1) CELL ("contents", A1) & CELL ("contents", A2) & CELL ("contents", A5)

or manages the trick ... probably some adjustments in the strings, but the principle is that: if you need a space to add between 2 strings insert a & "" & between the two.

HiSpeed 31-10-2009 05:34 PM

Re: Add contents of one cell to another
 
Thank you for your help.

I think I found another interesting alternative: the CONCATENATE formula:

=CONCATENATE("text text";A1;A2;"text")

CitricAcid 31-10-2009 05:41 PM

Re: Add contents of one cell to another
 
You can even do the same using the VBA coding as follows:

Code:

Sub addText()

Dim strMyText As String
strMyText = Cell("A1").Text

Cell("A1") = strMyText + Cell("A2").Text

End Sub



All times are GMT +5.5. The time now is 06:03 PM.