28 November 2007

How to addition text or digit after data in cell?

Tip for today, If you want to addition text or digit after data in cell for connect text or digit in new cell such as cell A1= 1234 , A2=2345, A3=3456 and add text "OK" in cell B1, you should be do
1.Select cell B1
2.Type =A1&"OK" and enter
3.Copy cell B1 to B2:B3
4.On cell B1:B3 will show
B1=> 1234OK
B2=> 2345OK
B3=> 3456OK

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.