Hello everyone...
I'm trying to do a spreadsheet that logs contact names and number
pulled from a network application. Normally I copy and paste the
information into one cell.
(cell a1) Ex: Steven Tyler p: 123-456-7890 f:369-125-1821.
How can I get 3 cells to seperate these and return:
Steven Tyler (in b1)
123-456-7890 (in c1)
369-125-1821 (in d1)
i cannot get it to remove the "p:" or "f:".
Please help if possible
Thanks, SJ
--
SubliminalJones
------------------------------------------------------------------------
SubliminalJones's Profile:
http://www.excelforum.com/member.php...o&userid=27597
View this thread:
http://www.excelforum.com/showthread...hreadid=475910