How do add text to cells in excel already containing text?

Question

How do add text to cells in excel already containing text?

Answer 1

you are able to not use a formulation to operate records to an present cellular's records. that ought to create a round reference, wherein the formulation in the cellular refers back to the cellular the formulation is in. Excel hates round references. you'll might want to apply VBA to create a macro/experience handler to do as you desire, if the textual content to operate isn't consistently an similar. in spite of the indisputable fact that, in case you needed to operate textual content to a cellular containing records it really is consistently an similar records to be further, you should use a custom format. as an get jointly, once you've a column of numeric values and also you needed to operate the textual content 'lbs' after each and each and every numeric fee, you should do so this way: pick the cellular(s) that you want to format and acceptable click in the chosen area. click 'format Cells'. pick 'custom' in the fashion tab. in the 'sort:' textbox replace the be conscious 'ordinary' with: #" lbs" click 'ok'. enter a fee in any of the formatted cells, and the 'lbs' will be further to the fee. So, 15 entered in a cellular will go back: 15 lbs One effective ingredient of it really is that, even even with the truth that the cellular consists of 'textual content', it really is disregarded even as making use of the cellular in computations. So, if the cellular containing 15 lbs became A1, and also you entered the formulation '=A1*2' in cellular B1, the outcome will be 30, no longer a '#fee!' blunders. If cellular B1 became formatted an similar as A1, the outcome should be '30 lbs'.

Answer 2

If the text is in columns A & B and column C is empty

in Cell C1 Create the formula =A1&"."&B1

Substitute the actual row you are on, in the formula

Copy the formula down as many rows as necessary

Highlight all the formulas Select copy then Paste special choose values

This will convert the formula's You can even paste them over column A if you want

To add text to a column you can still use the above method.

Place an & in front of the text and enclose it in " " marks.

example in column C =A1&" This text will be appended"



If you want to use Jeni's method I would insert a column between the two you want to merge and fill it with a dot in each row. That would save editing each row after the merge.

Jeni's method has the advantage of not needing extra columns, but the disadvantage of only working with one row at a time.

Answer 3

The following steps should help you:

1)Select the 2 cells you want to merge

2)merge them using the merge tab at the top of the page

3)click on the merged cell the text should appear at the top of the screen in the formula bar

4)you can then edit your text here ok.

to add text to a cell use the same steps ie click on the cell you want to edit and then use the formula bar at the top of the screen to edit your text hope this helps you!!

Answer 4

copy the 2 columns at the same time and paste them into an empty text file.



copy the "tab" space using CTRL+C, do a replace all, CTRL+V to paste the "tab" in the "Find" box, then in the replace with, just type a "." and click replace all.



You can then copy the whole thing back into the excel and it'd only take 1 column.

Answer 5

Use the CONCATENATE function so assuming text in A1 and B1 then make C1=CONCATENATE(A1,".",B1). Add a word in the same way, so if A1="Bill" then add "Smith" with B1=CONCATENATE(A1,"Smith")