Adding more information to a column of cells?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pete C - 16 May 2008 14:49 GMT

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 to this Message

Gary''s Student - 16 May 2008 15:06 GMT

1. select the cells
2. Format > Cells... > Number > Custom > General"rabbit"

Signature

Gary''s Student - gsnu200786

Reply to this Message

FSt1 - 16 May 2008 15:13 GMT

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

> Is it possible to add more to a cell?
>
[quoted text clipped - 12 lines]
>
> Pete

Reply to this Message