Excel help please?

Joins several text strings into one text string.

Syntax

CONCATENATE (text1,text2,...)

Text1, text2, ... are 1 to 30 text items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references.

Remarks

You can also use the ampersand (&) calculation operator instead of the CONCATENATE function to join text items. For example, =A1&B1 returns the same value as =CONCATENATE(A1,B1).

Example

The example may be easier to understand if you copy it to a blank worksheet.

How to copy an example

Create a blank workbook or worksheet.

Select the example in the Help topic.

Note Do not select the row or column headers.

Selecting an example from Help

Press CTRL+C.

In the worksheet, select cell A1, and press CTRL+V.

To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.

1

2

3

4

A

Data

brook trout

species

32

Formula Description

=CONCATENATE("Stream population for ",A2," ",A3," is ",A4,"/mile") Concatenates a sentence from the data above (Stream population for brook trout species is 32/mile)

Alternatively (a simple one):

Sub join()

Dim i As Integer

For i = 1 To 8

Cells(i, 3).Value = Cells(i, 1) + Cells(i, 2)

Next i

End Sub

here, depending on how many rows of info you have, you'd want to change the number '8'. For example, if you need to join 783 rows of information, just change the 8 to 783. Basically, for each row, this "adds" the stuff in the first column to the stuff in the second column, and puts the result in the third column. The change the '1','2','3' values in the code to customize it. For example, if you wanted to add the stuff in column 3 to the stuff in column 12, and put it in column 4, then the code would look like:

Cells(i, 4).Value = Cells(i, 3) + Cells(i, 12)

Good luck

this could take place if the cellular is formatted for dates in the past you enter the fee. attempting to alter the format mutually as there's a value in the cellular won't help, for the reason that a diverse inner fee is already being utilized by employing Excel. (some human beings write their dates that way, so Excel obliges. uncertain the type you purchased 42345, with the aid of fact the extensive form 41078 is how Excel internally represents the date June 18 2012.) The cellular ought to be usually or extensive form format *in the past* entering into the extensive form you choose.

If you have an Excel question go visit Mr. Excel.com. It is a great website with lots of help from professionals.