wayne_turner69
New Member
- Joined
- Sep 19, 2006
- Messages
- 1
I need to paste a formula with the same value in a collum. When I copy cell 1 and paste in 2 - 10 it increments the number.
ex
1. left(a1,2) (Original)
after paste
2. left(a2,2)
3. left(a3,2)
I need the value left(a1,2) in all cells.
Thanks for the help.
ex
1. left(a1,2) (Original)
after paste
2. left(a2,2)
3. left(a3,2)
I need the value left(a1,2) in all cells.
Thanks for the help.