AUTOTEXT Feature of Word in Excel

Hi all
My name is Arpit and i work in call centre of OCA and there i have to
work in MS-EXCEL and in that I have to enter different data values as
per a particular assigned format For eg:

Ryan,04/01/05,Paid by BCBS AL,Dt.12/03/05,Amt45.00$,Rest Pt.Resp
Brian,12/05/05,Paid by BCBS AL,Dt.05/03/05,Amt22.00$,Rest Pt.Resp

Now this is the format i have to enter data in every cell.Now as you
can see that some words are repeating in every cell like "Paid by BCBC
AL",Dt.,Amt.These also i have to type everytime for each new entry.

Is there a way to automate the repeating words so that my works becomes
easier and faster.

hoping for a quick response.
Thnks
Arpit

Arpit

Possible solution? in *.templates, no need to multi-post

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Arpit" <emailtoarpit@gmail.com> wrote in message
news:1117947509.114833.39820@g47g2000cwa.googlegroups.com...
> Hi all
> My name is Arpit and i work in call centre of OCA and there i have to
> work in MS-EXCEL and in that I have to enter different data values as
> per a particular assigned format For eg:
>
> Ryan,04/01/05,Paid by BCBS AL,Dt.12/03/05,Amt45.00$,Rest Pt.Resp
> Brian,12/05/05,Paid by BCBS AL,Dt.05/03/05,Amt22.00$,Rest Pt.Resp
>
> Now this is the format i have to enter data in every cell.Now as you
> can see that some words are repeating in every cell like "Paid by BCBC
> AL",Dt.,Amt.These also i have to type everytime for each new entry.
>
> Is there a way to automate the repeating words so that my works becomes
> easier and faster.
>
> hoping for a quick response.
> Thnks
> Arpit
>