access a cell in excel for mac without a mouse

Below you will find 3 methods of quick range concatenation in Excel.

Often you may want to split the content of one cell into individual cells, or do the opposite - combine data from two or more columns into a single column.

Common examples that require concatenation in Excel are joining names and address parts, combining text with a formula-driven value, displaying dates and times in the desired format, to name a few.

As a result, you have one larger cell that is displayed across multiple rows andor columns in your worksheet.

In other words, concatenation in Excel is the process of joining two or more values together.

This method is often used to combine a few pieces of text that reside in different cells (technically, these are called text strings or simply strings ) or insert a formula-calculated value in the middle of some text.

Although the CONCATENATE function is kept for backward compatibility, it is recommended to use CONCAT instead because Microsoft does not give any promises that CONCATENATE will be available in future versions of Excel.

You can also use it to concatenate various text strings to make the result more meaningful.

Please notice that we add a space before the word completed to separate the concatenated text strings.

The detailed instructions can be found in How to replace formulas with values in Excel.

For example, you should write CONCATENATE(A1, A2, A3) instead of CONCATENATE(A1:A3).

This method come in very handy in many scenarios because typing the ampersand sign () is much quicker than typing the word concatenate:).

Other than that, there is no difference between these two concatenation methods, nor is there any speed difference between the CONCATENATE and formulas.

Some users find CONCATENATE formulas easier to read, I personally prefer using the method.

So, simply stick to the concatenation technique that you feel more comfortable with.

Remember to enclose that character in quotation marks, as demonstrated in the following examples.

In some cases, however, may need to separate the values with a line break, or carriage return.

A common example is merging mailing addresses from data in separate columns.

The merged values are separated with a comma (, ), space ( ) and a line break CHAR(10).

To do this, press Ctrl 1 to open the Format Cells dialog, switch to the Alignment tab and check the Wrap text box.

When you are dragging the fill handle to copy the formula, the mouse pointer changes to a cross, as shown in the screenshot below.

If there happen to be empty cells in your table, say cell A6 and B6 were blank in this example, the formula would be copied up to row 5 only.

In this case, you would need to drag the fill handle down manually to concatenate the entire columns.

A large range would be tedious to add, typing each cell reference manually.

Access A Cell In Excel For Mac Without A Mouse