View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Brad Brad is offline
external usenet poster
 
Posts: 846
Default Not sure how to explain....

What I would do if I had to do this.
type in 1-1/2 in one cell
then 1-1/8 in the next cell
..
..
..

When all values are typed in
in the cell just to the right (or left)
="350TT-D-"&A4
and copy this equation down.

Does this help??


"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!