Excel Help

kicks66 · 15 Aug 2006 at 13:55

ive got a load of data with hyphens - in it, is there a way to get it to just display text characters?

also, is there a way to get excel to count all cells that are similar or the same as each other without a set criteria (ie cat, bat, bat, mat, rat would be grouped as 1 cat, 2 bat, 1 mat, 1 rat)

kicks66 · 15 Aug 2006 at 14:29

ive heard of pivot tables. no idea how to do it though...

kicks66 · 15 Aug 2006 at 14:41

ive got the hyphens removed and stuff

ill try your other suggestion for the data, the pivot table didnt seem to agree with me :/

kicks66 · 15 Aug 2006 at 15:52

ive got another dilemna. ive soted my original thing out. ive got a vlookup that will sometimes lookup a value when it doesnt exist, which will then show as #N/A. is there anyway i can get it so that it will just show a blank space?

kicks66 · 15 Aug 2006 at 16:42

yep, found that out for myself, done and done now, thanks for all your help