Text Formating

B

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
 
D

Dave O

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.
 
B

Ben

It works! But.....I get a #VALUE! if the name does not have a
firstname and initial, can you help?
 
D

Dave O

Sorry for the delayed response- try this:
=IF(ISNUMBER(FIND(" ",D7,1)),MID(D7,1,FIND(" ",D7,1)-1),D7)
 
Top