| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Computations involving text cells are not working??
=IF(c2="ABC",TRUE,FALSE) doesn't do anything
=(a2 & b2) doesn't concatenate 2 text cells =CONCATENATE(A2,B2) DOESN'T CONCATENATE 2 CELLS All arithmetic computations seem to work OK |
|
#2
|
|||
|
|||
|
Not sure where the question was, or what the question is, but you can try
putting these in front of the range that contains text (or reference to a cell that contains a text number): -- Which will for example turn a text string of " 005" to the number 5. "Text Cell Computations" <Text Cell wrote in message ... =IF(c2="ABC",TRUE,FALSE) doesn't do anything =(a2 & b2) doesn't concatenate 2 text cells =CONCATENATE(A2,B2) DOESN'T CONCATENATE 2 CELLS All arithmetic computations seem to work OK |
|
#3
|
|||
|
|||
|
In all cases, what were the values of the cells involved? What answers did
you get? -- Kind Regards, Niek Otten Microsoft MVP - Excel "Text Cell Computations" <Text Cell wrote in message ... =IF(c2="ABC",TRUE,FALSE) doesn't do anything =(a2 & b2) doesn't concatenate 2 text cells =CONCATENATE(A2,B2) DOESN'T CONCATENATE 2 CELLS All arithmetic computations seem to work OK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Searching for text in cells | Excel Discussion (Misc queries) | |||
| how do i add the same text after current text in multiple cells | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| How do I get merged cells to display all text. | Excel Discussion (Misc queries) | |||
| blank cells that include text | Excel Worksheet Functions | |||
Linear Mode
