I'm using excel 2003.
When i join the content of two cell, using the & formula, i want to perform
a frequency function on the new cell, but it gives back a result of 0,
although if i type the data of the two cells into one manually and perform
the task it works fine. Any ideas on what i can do so it will recognise the
data in the new cell