seperate data from 1 cell to 2 2

[JaredTaylor74]

Hey all,

i have a column in excel with data that looks like this...

15-02BD
15-02T
15-04NP
15-07SSD
15-08NP
15-12SSBD

The information I need is the text after the first 5 characters. the BD, T, NP.. etc my column is 8000 long so i'd rather not do it all manually. any formula's out there that could help me out?

Thanks,
Jared

 

[KenWright]

Select all the data, do data / text to columns / fixed width / set a break after the 5th character, hit next, select first column and choose not to import the column, hit next and finish.

Regards
Ken.................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
---------------- Click here to help the tsunami victims ----------------

 

[JaredTaylor74]

Perfect Ken, did the trick.

Thank you.

Jared

 

[KenWright]

You're welcome

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
---------------- Click here to help the tsunami victims ----------------

 

[DeLaMartre]

Thanks for the great reminder re text to columns, Ken. Another star!


-Bob in California