Concatenate cells

  • Thread starter Thread starter chinny03
  • Start date Start date
C

chinny03

I have data in Column A that needs to be concatenated to values entered by
the user.

For example,

"input from user" & " cell A1 & "input from user"
"input from user" & " cell A2 & "input from user"
"input from user" & " cell A3 & "input from user"

this would continue until all the way to cell A1000

The results of the concatenation would then be displayed in cell B1, B2, B3.
 
User has to input the values into a cell or cells.

Then =D1 & " " & A1 & " " & E1

You decide where the input cell(s) should be.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro - searches for key word in a column and concatenates entire 6
Excel Need Countifs Formula Help 0
Need macro that concatenates cells with text 7
macro to set bottom and top values for randbetween 6
Altered pasting functionality 3
cant seem to get a function to reference a variable cell? 1
Dynamic Named Cell 1
Macro to concatenate columns 1

Back
Top