Re first intials

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Biff (biffinpitt_at_comcast.net)
Date: 07/09/04 

Date: Thu, 8 Jul 2004 21:45:15 -0700

Hi Steved!

You'd be better off parsing the data with Text to Columns
using either the "space" or "," (comma) delimiter.

Make it easy on yourself!

Biff

>-----Original Message-----
>Hello From Steved
>
>Iwas kindly given the below formula which is for 2 first
>names.
>=B2&". "&LEFT(C2,1)&", "& MID(C2,FIND(" ",C2)+1,1)
>
>My question is I have over 1 thousand names, some have 1
>for first name same have 2 for first and i found that
>some have 3 first names, is the above formula capable to
>be changed to reconize 1,2 or 3 first names and return
>just the initials please. ie J,P,S
>
>Thankyou.
>.
>

Relevant Pages

  • Parsing Question
    ... I've done parsing where you have one delimiter such as a comma or ... These dates are extracted from Excel cells as strings. ... To first run the usual parse routine where the delimiter is the ...
    (microsoft.public.vb.general.discussion)
  • Re: time stamp, file length
    ... How do i stretch both files to make it same lenghth assigning 0 or blank to data pts which are missing. ... you showed us has space, not comma, as the delimiter. ... Can you help me to read this .csv file ?properly so i can convert the first column into a string using datenum. ...
    (comp.soft-sys.matlab)
  • Re: Reading just one field of a comma separated line
    ... where the values represented by firstfield* were the desired strings, ... :>> comma, ... :>> first field. ... :> embedded comma from a delimiter comma? ...
    (microsoft.public.vb.general.discussion)
  • Re: Subtotals technical question
    ... In excel, the most common delimiter is usually a comma, but could be ... For me, it's the comma. ... lists. ... Or you can specify "delimited" and be able to choose your delimiter (even type ...
    (microsoft.public.excel)
  • RE: Trying to split up info in one cell to several
    ... Using Excel '03, I tried what you're having a problem with and seemed to ... Started with this in one cell: |1015 Bond St., Suite 299, Baltimore, MD ... Used Text to Columns, Delimited, set delimiter to Comma & removed check ... Comma, and in Step 3 clicked to select first column & set option to Do Not ...
    (microsoft.public.excel.misc)