Splitting a cell and removing the columns

  • Thread starter Thread starter Joyce Clarke
  • Start date Start date
J

Joyce Clarke

I am working in Excel 2000 and I have a column that I have
to remove the commas, No problem I can format that
change, but I also have to split the numbers, For example
the cell reads 7,997,301. I want two columns, one with the
7997 and the other with the 301.
Can you help me with the formula?

Thanks Joyce
 
Joyce,

Assuming value in A1, and assuming you want the thousand value,
in B1 enter =INT(A1/1000)
in C1 enter =A1-(B1*1000)
 
Try using the "Right" function , the first argument is the cell that you
want to split , the second argument is the number of characters from
the right that you need to return.
You can of course also do the same for "Left"
If you don't know how many characters are in the cell use "Len" to
return the number
Good luck
Moshe
 
Thanks this works also - Great.

jc
-----Original Message-----
Joyce,

Assuming value in A1, and assuming you want the thousand value,
in B1 enter =INT(A1/1000)
in C1 enter =A1-(B1*1000)

--

HTH

Bob Phillips




.
Click to expand...
 
Back
Top