EXCEL problem

I have a unit Negri enter it, but now, I would like to these Negri unit

the contents of the front or the back, each coupled with a fixed number of words, I would like to ask capable, There is no good side

law, or entirely easy way offer 30 hours.Thank you.

To Plus what the word?
Select those cells, the format – cell – digital – from the definition of the type of input, “plus” @ “character”.
Do not look at this line? & Connect with Fu
A1 & B1 & C1 A1 for the original number, B1 enter = A1 & “would like to increase the content of” b1, and then drag the fill handle! Can! If
added to the front of a1-for-release on the back! English is the attention to the double quotes!

another simple method to select Canada in the past several cells, right-click, Format Cells, custom, @ input, “adding content” can be! English quotation marks ah!
increase put in front of @ If you want to put behind Gerry unit in the front or the back of the contents of each are combined with a fixed number of characters in the cell format can be set up:
selected point range :Format> Cell> Digital> custom, and the back of the type of “G / common format” before and after the need to add the words, the middle of a “0”, to add to the attention of the English quotation marks, such as in front To increase the “Total” to be behind the increase in “dollars” to read “,” Total “0” dollars “,” If the contents of the original text was then in the middle of the “0” to “@”.
Added:
1 , As long as you have said, according to the type of “G / common format” to “,” Liao A “0” or “,” Liao A “G / common format” can be a.
2, “each cell left Kok has a small green triangle “This is the prompt you with the format of these cells is not the same as above, is a text format.A solution:1, copy the format:Click on set at the beginning of a good format cells> on the toolbar at the top of the format brush> Use the following form to brush all the cell brush about .2 to re-set format:The format set out in the first click the title bar, select all of a whole (not the same as they set out to enter the same content of cell All regions selected), then the above methods to re-set format.Assuming you have a good input in the content of the column A, B out at you first enter the corresponding cell:
= “you want to use the word in front of the Canadian replacement “& A1 &” you want to use the back of increases in the replacement of the word “
Note:If you only add to the front, then remove the back part; and vice versa.
With A first set of real data cells to replace the formula The A1.
The first formula is complete, copy the formula down to ..

finally understand what you mean it.Given the following two programs:
1, assume that your A1 Cell is 11,111, like putting the word “Liao A”.Then you enter the cell B1 in the formula
= “Liao A” & A1
this cell B1 can be, “Liao A11111”, and then you And then copy the formula down.
Choice after the completion of the B list, right, “copy” right “Paste Special “–>” value”, and then delete the A list.
2, you assume that out of A store is the number of license plate numbers, check out A, right, “Format Cells”, “number” of self-definition, it is defined as:”Liao A” G / common format
As for the Green 1.30, or text on behalf of its neighboring cells do not like the format, and so on.This will not affect the normal use, does not affect the effectiveness of print, do not have to completely ignore.


Leave a Reply