Separating Text And Numbers

  • Thread starter Thread starter Lane
  • Start date Start date
L

Lane

I work on a network and pull contact names and phone numbers off the ne
work and put them in a cell to split into notes. I have been usin
left() and right() formulas for the phone numbers but have yet to fin
a way to split out the contact name
 
Hi Lane!

Post examples of what you have and I'm sure we'll be able to help.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Lane!

For the benefit of others including Google searchers the string that
needed to be parsed was:

DANIEL DE TAR E. P: 408-879-1200 F: 408-879-9786

If the names all come over in the format of B37 use:

=LEFT(B37,FIND(":",B37)-3)
Returns: DANIEL DE TAR E.

Fortunately, I hope, there's a unique character (:) that we can hook
on to for finding the length of the string that we need to extract.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Lane!

Always pleased to help. See how much easier it is when you have an
example for us to work off. In this case we only needed an example of
the entry that you wanted to be parsed.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top