add a part in a cell

KATSALAS

Board Regular
Joined
Sep 14, 2004
Messages
60
how to add in a cell that the content has a number at the end...
example:

a1
a2
a3
......
a1000

to

a1.pdf
a2.pdf
a3.pdf
.........
a1000.pdf
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

babycody

Well-known Member
Joined
Jul 8, 2003
Messages
1,395
Is this what you are looking for?
Book2
ABCD
1a1a1.pdf
2a2a2.pdf
3a3a3.pdf
4a4a4.pdf
5a5a5.pdf
6a6a6.pdf
7a7a7.pdf
8a8a8.pdf
9a9a9.pdf
10a10a10.pdf
11a11a11.pdf
12a12a12.pdf
13a13a13.pdf
14a14a14.pdf
15a15a15.pdf
Sheet1


Another option :

\a#."pdf" could be used, if you are entering the number only into the cells, by going to format>cells>number tab>custom and pasting this custom format into the Type: box. If it already has an "a" before the numbers then someone who is better than me at custom formats could probably help you with that.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,081
Messages
5,570,086
Members
412,310
Latest member
mark884
Top