Thanks June7
What I meant was I looked at using the functions such as "Substitute" or "If" in the cells which allowed me to swap say Ace of Clubs is converted to 1 or King of Diamonds is converted to 50 but not any card and then its numerical value.
Since I just look at this as a hobby I will look at VLookup and play with it.
Thanks for the input.