Thank you for your reply Anders. I'll do that and see how that goes.
Hi Purfleet, How could I set up my data to make it more easier to split it apart?5
Great, thanks for trying Purfleet. Appreciate the help.
Thanks Purfleet for your help and time.....works good.
Hi Purfleet, Thanks for responding to my post. I'll add the Mr. and Mrs, etc to the data. The formula you provided me resulted in a 0 in the last...
Hi Sunny, Thanks for responding to my request. Yes, that is a little bit confusing, I'm not sure how that all works. Will those formulas work if ...
Hi Anders, Thanks for responding. I got another piece of my project which was extracting the street number and name. However, I do have a questio...
Hi Eskilstuna, Here is the file, I apologize, I thought it was uploaded. Can you take another look at it? Thank you. Joseph
Hi Anders, I think I will take your advice and scrap my original data and try to make it more what you suggest to do. After I get it improved I w...
I just want to thank you for the great advice and help. This is just a project I was doing for my excel class. I wanted to show everything from bonus...
Hi Anders, Thanks for replying and my apologies for giving the wrong spreadsheet. Yes I have looked at the link you provided me. I also attached...