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?

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.

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")

Re: Add contents of one cell to another
 

You can even do the same using the VBA coding as follows: