Extracting Information 1 column to 2 columns

[Craig]

I would like to extract information from one cell and put
it into two cells.

Here is sample data in column A:

Column A
--------------------------------------------------
ACHMGEAA Germany, Achim, Embserbruch, 28832 Achim
ADSNTXAE US, TX, Dallas, 5080 Spectrum Center
--------------------------------------------------

This is what I would like:

Column B| Column C (character count will vary)
--------| ----------------------------------------
ACHMGEAA| Germany, Achim, Embserbruch, 28832 Achim
ADSNTXAE| US, TX, Dallas, 5080 Spectrum Center
--------| ----------------------------------------

The first 8 characters should be in one cell and the
remainder of the characters should be in a second cell.

I was able to extract the first 8 characters with this
formula in cell B2: =LEFT(A2, 8) but I don't know how to
extract the remainder of the cells into cell C.

Thanks.

 

[Norman Harker]

Hi Craig!

Use:
=RIGHT(A1,LEN(A1)-9)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

Hi
try for the second part in column C
=MID(A2,10,1024)

 

[Guest]

Awesome - thank you!

Both of these worked:
=RIGHT(A2,LEN(A2)-9)
=MID(A2,10,1024)

Craig