-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
add a part in a cell
- Thread starter KATSALAS
- Start date
babycody
Well-known Member
- Joined
- Jul 8, 2003
- Messages
- 1,395
Is this what you are looking for?
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.
| Book2 | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | a1 | a1.pdf | ||||
| 2 | a2 | a2.pdf | ||||
| 3 | a3 | a3.pdf | ||||
| 4 | a4 | a4.pdf | ||||
| 5 | a5 | a5.pdf | ||||
| 6 | a6 | a6.pdf | ||||
| 7 | a7 | a7.pdf | ||||
| 8 | a8 | a8.pdf | ||||
| 9 | a9 | a9.pdf | ||||
| 10 | a10 | a10.pdf | ||||
| 11 | a11 | a11.pdf | ||||
| 12 | a12 | a12.pdf | ||||
| 13 | a13 | a13.pdf | ||||
| 14 | a14 | a14.pdf | ||||
| 15 | a15 | a15.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.
Upvote
0
Similar threads
- Solved
