| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Add same text to the end of each cell
I have a column of numbers and i just want to add .jpg to each cell in the column.
How can I make excel do this in one go? so that i turn 777 888 2343 into 777.jpg 888.jpg 2343.jpg thanks! |
|
#2
|
|||
|
|||
|
Quote:
A1 = 777 the formula should be: =CONCATENATE(A1,".jpg")
__________________
Asobi Wa Owari Da |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to manually copy text from one cell to end of other text cell | Excel Discussion (Misc queries) | |||
| Enter text in a cell to return a text value in same cell | Excel Discussion (Misc queries) | |||
| Find text in a cell and copy text to another cell | Excel Discussion (Misc queries) | |||
| Copy text from cell to cell with one cell changing text | Excel Worksheet Functions | |||
| New text added to cell AFTER current text in same cell | Excel Worksheet Functions | |||
Linear Mode
