Want to link a cell of numbers with a cell of text & can sort
 

I have a column of #s and a column of text. The column of text describes
the column of numbers. I don't want to have to retype either column. Is it
possible to LINK/CONNECT the two columns so that they will act as one unitl?
If I try to merge the cells in the same row of the two different columns I
lose the text.
This is important because I must monthly import data and the data in the
columns could either increase or decrease.
Please advise.
Thank YOul

Want to link a cell of numbers with a cell of text & can sort
 

hi
you might consider a formula.
=A2&B2
if you need a space between the numbers and text....
=A2&" "&B2

regards
FSt1


"Holly" wrote:

I have a column of #s and a column of text. The column of text describes
the column of numbers. I don't want to have to retype either column. Is it
possible to LINK/CONNECT the two columns so that they will act as one unitl?
If I try to merge the cells in the same row of the two different columns I
lose the text.
This is important because I must monthly import data and the data in the
columns could either increase or decrease.
Please advise.
Thank YOul