Splitting numbers in a column

[Neil Adam]

I am using Excel 2002 and have a column of numbers anywhere between 8 and
16 digits in length that may also contain spaces or dashes. What I need to
do is get the first and last 4 numbers into separate columns, (which I will
merge later).Basically I need to throw out everything in the middle and end
up with only the two outside four digits, (giving me an 8 digit number).

Any help would be greatly appreciated.

Neil.

 

[Earl Kiosterud]

Neil,

In the column for first 4 digits:
=Value(Left(A2, 4))
In the column for last 4 digits:
=Value(Right(A2, 4))

 

[JulieD]

Hi Neil

to get the 8 digit number in a cell using the first four & last four try
=VALUE(LEFT(A1,4) & RIGHT(A1,4))
where A1 has your original number

Cheers
JulieD

 

[glenthompson]

I am not really having any luck with the formulas above. When I put in:

*=VALUE(LEFT(A1,4))* as above I get a "Value" error.

What I am trying to do is get part of the string in A1 (I thought th
above would return the first 4 characters of A1.

Is there a way to do this?

Also is there a way to get the 4th to the last character in a string
Some kind of a =VALUE(LEFT(A1,4,length(A1))) or something?

Please help, ask if my question needs clarification. Thanks!

Gle

 

[JulieD]

Hi

what is in cell A1
what does
=LEFT(A1,4)
give you?

for your other question try
=MID(A1,4,LEN(A1-4))

Cheers
JulieD