LinkBack URL
About LinkBacks
kkocak 
You can do it via formula something like in column B:
=LEFT(A1,4) & "-" & RIGHT(A1,LEN(A1)-4)
then copy down all the values in column A will appear in column B as 2007-076 format.
You can do it via formula something like in column B:
=LEFT(A1,4) & "-" & RIGHT(A1,LEN(A1)-4)
then copy down all the values in column A will appear in column B as 2007-076 format.
Not all forums are the same - seek and you shall find
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks