One way would be to set up Tools | Autocorrect to change some
character (like #) to 350TT-1- and then all you need to do is type
#1/12 and it will be converted into 350TT-1-1/12 automatically.

Remember to delete that autocorrect setting once you're done.

Hope this helps.

Pete

On Jan 17, 4:26*pm, Tricia LeAnn
wrote:
I tried that.... And either I did it wrong, or that's not what I'm looking
for.
Here's a better example:
350TT-1-1/12
350TT-1-3/4
350TT-1-1/16
350TT-1-1/2
350TT-1-1/8

I want to be able to start every line with 350TT- and not have to retype it
each time. I would rather just do that part seperately. That way I can use
the number pad, and it would take a lot less time than having to go back and
forth between the number pad and letters on the keyboard. Does that make more
sense?



"John Moore" wrote:
Hi, I think your looking for an easy LEFT ,,, just enter =LEFT(A1,5) ,,
assuming A1 is where your data starts, and copy the formula down to the end
of your data.

"Tricia LeAnn" wrote:

Ok.. I don't know how to explain what I'm asking, so I'll just give an example.

I have to enter in A TON of data containing both letters and numbers. All of
them start with 350TT.... and then it end up looking something like this:
350TT-D-1-1/2"-2"

I would like to be able to start each line with 350TT and not have to
re-type it... So I guess what I'm asking is... Is there a way to
automatically make each line start with that, and not automatically erase it
when I start putting in the numbers? In other words, I don't want to have to
go back and forth between letters and numbers. It would be easier to do
separately.

Does that make any sense? If so, please help. Thanks!- Hide quoted text -

- Show quoted text -