Add text to a non-empty cell
Hello,
I am new to Excel,
I need help to know how to add text to a non-empty cell.
On Excel 2010 (and for a beginner like me) (I don’t know what macros are)
In 900 cells, I need to put, for example, "store" before the store name in the same cell.
I cannot copy and paste because each cell has a different name.
Or is it possible to merge two columns and keep both texts?
Thanks in advance.
Configuration: Windows / Chrome 59.0.3071.115
I am new to Excel,
I need help to know how to add text to a non-empty cell.
On Excel 2010 (and for a beginner like me) (I don’t know what macros are)
In 900 cells, I need to put, for example, "store" before the store name in the same cell.
I cannot copy and paste because each cell has a different name.
Or is it possible to merge two columns and keep both texts?
Thanks in advance.
Configuration: Windows / Chrome 59.0.3071.115
3 answers
-
Hello
In a new column="Store " &A2
Copy downwards
Then copy the column and Paste Special (text) -
Contributor... and above all, do not merge!
--
Retirement is great! Especially in the Caribbean... :-)
Raymond (INSA, AFPA, CF/R) -
Hello
More simply, if it’s just a matter of changing the display, select the 900 cells, then right-click Cell Format - Custom and enter in Type: ""store "@
Best regards
Via
--
"Imagination is more important than knowledge." A. Einstein
