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

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
 
F

FSt1

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

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

Macro to add numbers in a text string 5
Appending Text To Numbers ? 1
How can I remove diff. numbers from a cell combined with text 5
Comparing 2 blocks of text and data 2
separation of text and numbers in an unmerged cell 9
conditional formating with text 5
Cannot sort data 6
VBA- IF statement to replace cell contents 0

Top