Looking for easier way to create my spread sheet.

Currently i Cut and paste most of my info from a Word RTF File then i have to enter in by hand all the route numbers.

For example:

when i paste into Excel it looks like this

(spaces are the different boxes)

AM-Region: CH1 AM-Route: 1
32779 ALL PAWS VETERINARY CLINIC 1111111111 7/21/2008
32544 CRYSTAL LAKE VET 11111111111 7/21/2008
32642 ELGIN WESTSIDE 1111111111 7/21/2008
AM-Region: CH1 AM-Route: 2
32016 ABERDEEN ANIMAL HOSPITAL 11111111111 7/21/2008 9:29
33272 NILES ANIMAL HOSPITAL 11111111111 7/21/2008 10:31

What i am trying to do is have Excel take the info from where it says CH1 and the 1 after but also have it put AM Between the 1's. to look like this.

CH1AM1

Basically the final project i want is

CH1AM1 32779 ALL PAWS VETERINARY CLINIC
CH1AM1 32544 CRYSTAL LAKE VET
CH1AM1 32642 ELGIN WESTSIDE
CH1AM2 32016 ABERDEEN ANIMAL HOSPTIAL

I JUST WANT TO KNOW IF THIS IS POSSIBLE.

REASON I WANT TO FIND A FASTER WAY, IS I HAVE TO DO THIS EVERY WEEK AND THE EASIER I MAKE IT AND THE LESS I HAVE TO TYPE IN THE LESS MISTAKES I WILL MAKE.

Hi

See how this goes

Please Login or Register  to view this content.

rylo