Is there a way to actually move the data without a formula...

Cause I want later to seperate them out again.

Client City, State ZIP From MAITLAND F L 3XXX1 To
IRVINE CA 9XXX2
Client Business phone From 555-XXX-XX4 0 To
999-XXX-0XX1
Client Fax Number From 555-XXX-XX3 0 To
999-XXX-0XX6
Client Address line 0 From C/O CLIENT N AME To
INTERNATIONAL


So what I need to do is pull the information back together then put the
from in one column and the to in another column. As well as the first
part the identifier of the information.


--
JustMe602
------------------------------------------------------------------------
JustMe602's Profile: http://www.excelforum.com/member.php...o&userid=27854
View this thread: http://www.excelforum.com/showthread...hreadid=498801