IN EXCEL, HOW SHOULD YOU WRITE THE CONTENTS OF MANY CELLS INTO ONE CELL???

Strings can be processed with "=phonetic(region)", and for numbers, he will not merge numbers into concatenate() as well

To fill in eight cells one by one, and there are limitations, troublesome given that there is no suitable formula, you can try excel

Macros to customize a formula to complete your functional tool|

Macros|visual

Basic.

Turn on the VB.

asrange)

asstringdimyas

stringdim

zforeachzin

ycstr(z)next

zmayend

function and then close the vb generator to enter in any cell in excel.

For example=myfunc(f1:f100) is fine, the following is the effect, very convenient, isn't it?

Follow the steps below to achieve this;

1. Select column F and right-click - set the cell format - number (select text) - OK.

2. Enter text or numbers in column F.

3. Enter the formula in cell A1: =phonetic(F1:F100) The formula F1 and F100 are set by you.

This merger has a maximum of 30 each. You can use the concatenate function: =concatenatef(concatenatef(f60," f61," f62," f63," f64," f65," f66," f67," f68," f69," f70," f71," f72," f73," f74," f75," concatenatef(f76," f77," f78," f79," f80," f81," f82," f83," f84," f85," f86," f87," f88," f89," f90," concatenatef(f91," f92," f93," f94," f95," f96," f97," f98," f99," f100)

Follow the steps below to achieve this; 1. Select column F and right-click - set the cell format - number (select text) - OK. 2. Enter text or numbers in column F. 3. Enter the formula in cell A1:

Phonetic(F1:F100) The formula in which F1 and F100 are set by you.

Copy the items you want to merge together into Word, and then copy them from Word to Excel. Note that you must double-click on the cell, i.e. paste if there is a cursor in the cell.

The second floor is not Japanese.

If you want to use functions, as far as I know, there is no such thing VBA macro program is not very general, it seems unnecessary to write, a bit of chicken ribs So I thought of a way that is not a way First of all, assume that the form of the data is in the same column, for example, you said f1:f100, and the g column is empty, then enter the formula =f1 in g1, and then enter the formula =g1&f2 in g2, and then fill it down from g3, It is to double-click on the small black dot in the lower right corner of g2 or hold down the small black dot and drag it to g100, and then the content of g100 is the string until f1 merges to f100, if you only need data, right-click --- paste the value selectively --- the value --- OK Or there is another way, which is to use the concatenate function, and then click the cells you want one by one with the mouse, so that you don't have to play too many connection symbols&.

It's easy, just insert the g column to the right of the f column, and let g60=f60 and g61=g60&"f61 Finally, use the formula of g61 to copy down The method of copying, select the cell, observe that there is a small black square in the lower right corner, the mouse hover will become a solid cross, drag down or double-click to copy it.

You can't fit that much in a cell. There is a limit to the number of bytes in a cell.

If you have to, the quickest way is to use a VBA

Otherwise, the formula, too, is troublesome. Like what.

You're going to merge a1:a1000 together.

Then B2 inputs.

b1&a1 pull-down padding to b1001

B1001 is what you want.

I want to tell you that this is probably the only way. You copy and paste the contents of these thousands of cells into Word first, and then use Word's **--convert--** to convert to text, and then all the tabs are gone, ** is gone, and then all the content can be placed under one cell.

Use hidden functions.

phonetic (raw data region).

Data regions must be in text format, ignoring numbers.

If h1, h2, h3 are text data, then insert a cell in the h1 cell, and then enter the following formula in the h1 cell.

phonetic(h2:h4)

Merge the text data of the h2:h4 cells together;

Then copy H1, after "Paste Special" to "Numeric", delete the H2:H4 cell, you can.

See the attached drawings for examples.

1: Enter =a2&a3 in the first cell

Note: A2 is the name of the second cell, A3 is the name of the third cell, 2: After you are done, put the cursor in the lower right corner of the cell, turn it into a black cross-shaped cursor, and drag it down.

If the contents of the three cells are located in A1, B1, C1 respectively, enter :. in E1 cell

a1&b1&c1

Or drag the mouse to select three squares. Right-click --Merge Cells.

h1=h1&h2&h3

Mistake. h4=h1&h2&h3

Correct, drag the fill handle.

Then copy column H and paste the -value selectively to column A. So column A does not contain formulas.

Drag the mouse to select three squares. Right-click --Merge Cells.

Press Ctrl to select one or more cells to be entered, enter what you want in the last selected cell and press Ctrl+Enter.

Selected regions. Enter your content in the field above.。。 Ctrl+Enter.

Select multiple cells at the same time, enter the content, press Ctrl+Enter, OK.

Select cell A1 and right-click"Cells know the bad format"--Lap and leak alignment"The tab --- bottom left"Stove shirt text control"--Word wrap"You can cancel the previous checkbox.

Merge A1 and B1 units to play the grid, you can show the empty stove together, and you can also put C1 and D1

All caves collapsed and merged.

It depends on your typography requirements.

If the contents of the three cells are located in a1, b1, c1 respectively, enter =a1&b1&c1 in cell e1 or drag the mouse to select the three cells. Right-click --Merge Cells.

h1=h1&h2&h3 error.

h4=h1&h2&h3 correct, drag the fill handle.

Then copy column H and paste the -value selectively to column A. So column A does not contain formulas.

Drag the mouse to select three squares. Right-click --Merge Cells.