Split a Value
 

Hello,

I was wondering if there is anyway to split a value from one cell to two
cells?

Currently A1 = 26.25 (integer), Is there a way to split this value to have
B1 = 26, and B2 = 25?

Split a Value
 

Highlight the column, then Data TextToColumns using the decimal point (or
period) as the delimiter........

Vaya con Dios,
Chuck, CABGx3




"Gabe" wrote:

Hello,

I was wondering if there is anyway to split a value from one cell to two
cells?

Currently A1 = 26.25 (integer), Is there a way to split this value to have
B1 = 26, and B2 = 25?

Split a Value
 

Hi, first make sure there is a blank column to the left of your data,
then select your data, go to Data/Text to Columns and use a period as
your delimiter!

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=494924

Split a Value
 

Pure genius, Thanks Chuck!

"CLR" wrote:

Highlight the column, then Data TextToColumns using the decimal point (or
period) as the delimiter........

Vaya con Dios,
Chuck, CABGx3




"Gabe" wrote:

Hello,

I was wondering if there is anyway to split a value from one cell to two
cells?

Currently A1 = 26.25 (integer), Is there a way to split this value to have
B1 = 26, and B2 = 25?

Split a Value
 

B1 =INT(A1)
B2 =(A1-B1)*100
If negative values possible use TRUNC

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Gabe" wrote in message
...
Hello,

I was wondering if there is anyway to split a value from one cell to two
cells?

Currently A1 = 26.25 (integer), Is there a way to split this value to
have
B1 = 26, and B2 = 25?