A List of Names Help
 

If I take a list of first names like the example below, is there a very quick way I can add a space and a 1 next to them all? The real list I am working with is about 500 long so I don't want to do each one individually.

FROM THIS:
Steve
Bill
Jim

TO THIS:
Steve 1
Bill 1
Jim 1

This relates to OOTP if confused. :)

I am guessing you are using Excel.

I would look up CONCATENATE in the Help pages. That will do it for you. Just set up a row besides the names and CONCATENATE the space and the 1 after the name column. Then copy and "paste special" over the name column, making sure to hit "Values" in the box that opens up when you use paste special.

Then delete the CONCATENATE column, so it doesn't screw with your csv import.

CR

I can use anything to do it, be it Word, Excel, or Notepad. Will lookup concatenate now!

I am just editing the DAT names files, not the CSV at this point.

Anyways, where do I put the CONCATENATE thing? In a whole new column, or just as a row above all my 1's?

It's the command you put in the actual cell.

Here is how I would do it
A1 Lynch
B1 (space)1
C1 =concatenate(A1,B1)

copy the formula all the way down

then copy column C
Do a paste special values on top of itself

delete columns a and b

Your new cell a1 will be Lynch 1

You can also concatenate in excel using the ampersand. For example, if your list of names is in column A, beginning with A1 and ending at A500 (A1:A500), you might enter a formula in B1 as follows:

= A1&" 1" [note: text must be enclosed in quote marks]

Then select B1:B500;

Then use the fill-down command to instantly enter the relative formula into each related column B cell;

Then, as suggested by lynchjm24, copy B1:B500;

Then, paste special/values;

and you've got it.

The key is the pasting of 'value.' The results you obtain in column C is actually the formula, so what shows up there is based upon existant data...if you delete that data (columns A and B), column C will then disappear as well.

Sorry if this is totally unnecessary :)

thank you all!