![]() |
Adding more information to a column of cells?
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 |
Adding more information to a column of cells?
1. select the cells
2. Format Cells... Number Custom General"rabbit" -- Gary''s Student - gsnu200786 |
Adding more information to a column of cells?
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 |
All times are GMT +1. The time now is 08:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com