Hi all
I think I need a formula that will take a cells contents but with this slight specifc criteria:
I creating a sheet in excel 2007 that people will need to fill data in and I want to autopopulate two of the columns (H and J) with data they input into column O
But if the data has a dot seperating words, I need only the words after the dot
So D1111.XP input into column O should be XP, and D1111 would be just D1111
Hope this makes sense
thanks in advance
Bookmarks