Adding more information to a column of cells?

P

Pete C

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
 
G

Gary''s Student

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

FSt1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Sort by number only in cell 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
adding the same prefix or suffix to a range of cells 5
Is it possible to split 1 cell into 3 cells w/o affecting other ce 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
adding text according to col with equal date 2
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2

Top