nhall
General User
Joined: 11 Jun 2004
Posts: 31
Location: West of Boston, MA, USA
|
 Posted: Mon Aug 30, 2004 7:17 am Post subject: Correct usage of Built-in formula FIND |
 |
|
As a learning exercise, I have saved many of the names associated with SPAM email sent to me. I have stored these names in a Calc spreadsheet. My goal is to parse the SPAM full names into FirstName and LastName and then generate a ShortName. Some of the names include a middle initial terminated by the special character PERIOD (.). Using the following formula in a spreadsheet cell, I can parse the SPAM name based on FINDing a BLANK " "
=IF (FIND(" ";SPAMName;1)<1);"A";"B"
where "A" & "B" are replace with appropriate formulas to isolate the first name plus initial and the first name.
The problem is that when I change the search argument in FIND from BLANK to Period, the formula becomes invalid and results in #VALUE. Can anyone tell me how to make PERIOD a valid search argument?
Norm |
|
