Thread: Parsing Data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pdberger pdberger is offline
external usenet poster
 
Posts: 258
Default Parsing Data

Good morning --

I'm trying to parse this:

A B C D
Alfred E Newman

into:

A B C D
Alfred E Newman

What I've written is:

Cells(iR, 1).Parse Destination:=Cells(iR, 2)

but it just copies the entire cell contents to the next row over. What am I
doing wrong?

TIA