Concatenate in Text box

[nagovind]

Hi all


How to display multiple cell results inside ONE text box. IF i use concatenate it is not working

 

[xld]

[pre]
TextBox1.Text = Range("A1").Value & Range("B2").Value
[/pre]

as an example

 

[nagovind]

Hi xld

thanks


Without using macros is it possible

i'm using a sheet without macros


i'm able to display simple cell content in text box by just typing = in formula bar and linking the cell but unable to concatenate multiple cells

 

[xld]

You could link it to a cell that has a formula that concatenates some others.

 

[Hui]

as XLD said in your text box use a simple =B1

In B1 use a concatenate or & eg:

B1:

=A1&A2&A3

or

=Concatenate(A1,A2,A3)

 

[KSRST SAI]

If we have to divide a number within a cell, how to do it?

I will explain further:

There are 300 numbers in a particular column.

All the numbers have to be divided by a particular number and

the result should come in the same cell in which the original number is there.

That is, 2367 to be divided by 7, what I am doing is, put '='before the number

and put '/' after the number and put '7' after '/' and enter. I am getting

the answer within the cell. But to do this for 300 numbers, it is a difficult task.

Is there any other method?

 

[vijaySharma]

@KSRST


Assuming the 300 numbers are in cells A1:A300

Assuming the number by which you need to divide are in B1:B300


Select all cells in B1:B300

Copy


Select All Cells in A1:A300

Edit - Paste Special

Click on Divide

Click on Ok


HTH

~VijaySharma

 

[Luke M]

@KRST

Method to divide a group of numbers by a constanst is to:

1. Type the constant (7) into a cell somewhere

2. Copy the cell

3. Select the cells you want to change

4. Edit - Paste Special. Choose the appropriate math operation (divide)

5. Ok out, Done.

 

[Hui]

KSRST SAI


Firstly Welcome to Chandoo.org Forums

I hope Luke and Vijay's responses have helped you


Can you please start a new posts for new questions, so that we can properly track and Tag posts