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

  • Thread starter Thread starter Holly
  • Start date Start date
H

Holly

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
 
hi
you might consider a formula.
=A2&B2
if you need a space between the numbers and text....
=A2&" "&B2

regards
FSt1
 
Back
Top