Splitting cells
 

in cell A1 i have the numbers 123456789. i want cell B1 to have numbers
1234567 and cell C1 to have just 89. what is the formula? i have tried text
to columns

Splitting cells
 

If this is for extracting the first 7 characters use LEFT()

=LEFT(A1,7)
=RIGHT(A1,2)

--
Jacob (MVP - Excel)


"fazz" wrote:

in cell A1 i have the numbers 123456789. i want cell B1 to have numbers
1234567 and cell C1 to have just 89. what is the formula? i have tried text
to columns

Splitting cells
 

Hello Jacob - i did not explain this very well.The digits in cell A1 is
variable length. In cell C1 i need the last 2 digits of cell A1. In cell B1 i
need the remainder of cell A1. this maybe more or less than 7 digits

"Jacob Skaria" wrote:

If this is for extracting the first 7 characters use LEFT()

=LEFT(A1,7)
=RIGHT(A1,2)

--
Jacob (MVP - Excel)


"fazz" wrote:

in cell A1 i have the numbers 123456789. i want cell B1 to have numbers
1234567 and cell C1 to have just 89. what is the formula? i have tried text
to columns

Splitting cells
 

Hi

in C1
=RIGHT(A1,2)
in B1
=IF(LEN(A1)2,LEFT(A1,LEN(A1)-2),A1)

--
Regards
Roger Govier

fazz wrote:
Hello Jacob - i did not explain this very well.The digits in cell A1 is

variable length. In cell C1 i need the last 2 digits of cell A1. In cell B1 i
need the remainder of cell A1. this maybe more or less than 7 digits

"Jacob Skaria" wrote:

If this is for extracting the first 7 characters use LEFT()

=LEFT(A1,7)
=RIGHT(A1,2)

--
Jacob (MVP - Excel)


"fazz" wrote:

in cell A1 i have the numbers 123456789. i want cell B1 to have numbers
1234567 and cell C1 to have just 89. what is the formula? i have tried text
to columns

Splitting cells
 

Change the 1st formula to

=LEFT(A1,LEN(A1)-2)

--
Jacob (MVP - Excel)


"fazz" wrote:

Hello Jacob - i did not explain this very well.The digits in cell A1 is
variable length. In cell C1 i need the last 2 digits of cell A1. In cell B1 i
need the remainder of cell A1. this maybe more or less than 7 digits

"Jacob Skaria" wrote:

If this is for extracting the first 7 characters use LEFT()

=LEFT(A1,7)
=RIGHT(A1,2)

--
Jacob (MVP - Excel)


"fazz" wrote:

in cell A1 i have the numbers 123456789. i want cell B1 to have numbers
1234567 and cell C1 to have just 89. what is the formula? i have tried text
to columns

Splitting cells
 

many thanks...thats done the job!

"Jacob Skaria" wrote:

Change the 1st formula to

=LEFT(A1,LEN(A1)-2)

--
Jacob (MVP - Excel)


"fazz" wrote:

Hello Jacob - i did not explain this very well.The digits in cell A1 is
variable length. In cell C1 i need the last 2 digits of cell A1. In cell B1 i
need the remainder of cell A1. this maybe more or less than 7 digits

"Jacob Skaria" wrote:

If this is for extracting the first 7 characters use LEFT()

=LEFT(A1,7)
=RIGHT(A1,2)

--
Jacob (MVP - Excel)


"fazz" wrote:

in cell A1 i have the numbers 123456789. i want cell B1 to have numbers
1234567 and cell C1 to have just 89. what is the formula? i have tried text
to columns