Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is it possible to add more to a cell?
For example, I have one column of cells numbering from 1 to 10. I want to add a prefix or suffix to the number therefore I get: 1rabbit 2rabbit 3rabbit 4rabbit etc.... For one cell that is. Thanks, Pete |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
1. select the cells
2. Format Cells... Number Custom General"rabbit" -- Gary''s Student - gsnu200786 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hi
aside from click into the cell and typing in the data, you could use a helper column with a formula.... =A1 & "rabbit" copy the formula down. you could then copy the helper column formula and paste special values over the original data. delete the helper column. a bit manual i admit but you did say how long your list was. based on your example this should do it. Regards FSt1 "Pete C" wrote: Is it possible to add more to a cell? For example, I have one column of cells numbering from 1 to 10. I want to add a prefix or suffix to the number therefore I get: 1rabbit 2rabbit 3rabbit 4rabbit etc.... For one cell that is. Thanks, Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
combine information in two cells into the third column | Excel Discussion (Misc queries) | |||
adding information to cells uniformally | Excel Discussion (Misc queries) | |||
I have a question about adding information to a list of items that have cells linked to another worksheet. | Excel Discussion (Misc queries) | |||
Adding same information to many cells... | Excel Discussion (Misc queries) | |||
Duplicate Data -Adding information to another column in row & dele | Excel Discussion (Misc queries) |