ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Adding more information to a column of cells? (https://www.excelbanter.com/excel-discussion-misc-queries/187734-adding-more-information-column-cells.html)

Pete C[_2_]

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

Gary''s Student

Adding more information to a column of cells?
 
1. select the cells
2. Format Cells... Number Custom General"rabbit"
--
Gary''s Student - gsnu200786

FSt1

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