I have a spreadsheet where 1 column = firstname and initial. For
example Dave C.
How can I mask the cell to be just the first name?
Thanks
Ben
I have a spreadsheet where 1 column = firstname and initial. For
example Dave C.
How can I mask the cell to be just the first name?
Thanks
Ben
Yes, using a formula like this
=MID(D7,1,FIND(" ",D7,1)-1)
where D7 contains the name in question. This formula returns
everything before the first blank space in the entry- which is great
until you run into Mary Ann X, who gets converted to Mary.
You da man, thank you
It works! But.....I get a #VALUE! if the name does not have a
firstname and initial, can you help?
Sorry for the delayed response- try this:
=IF(ISNUMBER(FIND(" ",D7,1)),MID(D7,1,FIND(" ",D7,1)-1),D7)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks