View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Arsenio Oloroso
 
Posts: n/a
Default Manipulating Cell Contents?

Can anyone help me with this problem?

I've imported data from a .pdf file into Excel. But some of the numbers
don't end up in the correct columns.

CARVER PRIMARY $3,547,3 03 $5,6
CASALS $4,406,4 52 $5,7
CASSELL $2,047,2 25 $6,7
CASTELLANOS $3,989,1 48 $5,0
CATHER $2,555,8 51 $6,4


In the third column, above, the two-digit numbers actually need to be
appended to the end of the numbers in column two. Is there a way I can cut
these numbers and move them over to the second column.

I suppose I could just type them in, but there are hundreds of these.

Any leads are much appreciated
OLY