Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Text Formating
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 |
#2
|
|||
|
|||
Text Formating
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. |
#3
|
|||
|
|||
Text Formating
You da man, thank you
|
#4
|
|||
|
|||
Text Formating
It works! But.....I get a #VALUE! if the name does not have a
firstname and initial, can you help? |
#5
|
|||
|
|||
Text Formating
Sorry for the delayed response- try this:
=IF(ISNUMBER(FIND(" ",D7,1)),MID(D7,1,FIND(" ",D7,1)-1),D7) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strange Formating problem with text and formula in same cell | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Formating text in cells | Excel Discussion (Misc queries) | |||
Conditional Formating when result is text | Excel Worksheet Functions | |||
Formating a text string? | Excel Discussion (Misc queries) |