Microsoft Office Forums - View Single Post - [Solved] Seperating text data

Thread: [Solved] Seperating text data

View Single Post

Old

10-31-2013, 03:48 AM

philb

philb is offline

philb uses Windows 7 64bit

Windows 7 64bit philb uses Office 2003

philb uses Office 2003

Office 2003

Novice

The original poster

Join Date: Oct 2013

Posts: 2

philb is on a distinguished road

Default

Seperating text data

Have following in A1

"Bloggs,Joe" < Joebloggs@gmail.com>

want to seperate so have

A1" Bloggs ,Joe"

B1 Joebloggs@gmail.com

any suggestions appreciated

Reply With Quote