LinkBack URL
About LinkBacksSimple really, but defeating meI is a Excel n00b
In an Excel spreadsheet I have a column of numbers, say 0 to 5000 and I want to prefix them all with
14- without inserting an extra column. How to do this?
Simple Excel question
Simple really, but defeating me
In an Excel spreadsheet I have a column of numbers, say 0 to 5000 and I want to prefix them all with
14- without inserting an extra column. How to do this?
[
Originally Posted by Blitzen
If the numbers are consecutive, use the formula ="14-"&(ROW()-1) and copy that into every cell. If the first row is on say, row 3, the formula becomes ="14-"&(ROW()-3)
If they're non-consecutive, then you're better off using a spare column, using the formula ="14-"&A1 (replace A1 with the appropriate column starting point and then using Paste Special -> Values to put the information back in.
(\___/) (\___/) (\___/) (\___/) (\___/) (\___/) (\___/)
(='.'=) (='.'=) (='.'=) (='.'=) (='.'=) (='.'=) (='.'=)
(")_(") (")_(") (")_(") (")_(") (")_(") (")_(") (")_(")
This is bunny and friends. He is fed up waiting for everyone to help him out, and decided to help himself instead!
0iD (10-01-2008)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote