Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Manipulating Cell Contents?
assuming the data has come through in three columns,(say A,B,C) in cell D1
type = B1&C1 or B1&" "&C1 if you want a space and copy down.Copy this row and paste special as a value onto column B,delete column C(Make a copy of your original file first) -- paul remove nospam for email addy! "Arsenio Oloroso" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |