| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell reference value to remain constant in a sort using Paste Link | Excel Discussion (Misc queries) | |||
| cell to cell text and link | Excel Worksheet Functions | |||
| if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
| if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
| Cell only shows link in text, not contents of reference cell | New Users to Excel | |||
Linear Mode
