Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell contents as the 'lookup value' parameter in HLOOKUP function | Excel Discussion (Misc queries) | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
Function syntax to compare cell contents | Excel Worksheet Functions | |||
How do I find the contents of a cell using the "ADDRESS" function. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |