Split a Value

G

Gabe

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?
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
P

pinmaster

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
 
G

Gabe

Pure genius, Thanks Chuck!

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

Vaya con Dios,
Chuck, CABGx3
Click to expand...
 
Top