Need Help Badly

I have a excel spreadsheet and one entire column is all phone numbers... The problem is, I need to have 1 before each number and it's not there now... How can I have the number 1 inserted before all these numbers (about 3000 or so)... I cannot bear the thought of going through each one and adding a 1 beofre the number..

Hello textboom,

Could you please change your thread title to be a little more descriptive of your problem?

As for the question.....Say your numbers are in A1:A3000. Try this formula in B1

=1&A1

copy this formula down column

in another column put=1&a1 where a1 is your first number,drag down to end, then copy/paste back special values

If the numbers, as they are currently, all start with a specific character - eg, a space, a 9, a ( you can do a find & replace using that character. I find this is easier to copy & paste into Word, convert table to text, Find ^p9 (hard return followed by a 9, so that it doesn't replace ALL 9s) and Replace with ^p19 - this is very simplistic way.

Or you can do directly in Excel. Add a new column before the column with your numbers. If your 1st number is in position B3, but a 1 in position A3. Then select that row (or just the selection matching your numbers) and go to Edit/Fill/Down. It will put 1s in all the cells.

Then in column C3, put this formula: =A3&B3 - this will concatenate the 2 cells, merging the data into the 1 cell.

The thing is that the concatenated cell requires the A3 & B3 for it to stay put. So either hide columns A & B (so the users don't see them but they're there for your concatenation formula).

OR if you really don't want those columns A & B, take the concatenated row C, select & paste it into Word, go to Table/Convert/Table to Text. This just puts the concatenated number - not the formula. Then copy & paste that back into Excel.

Hope this helps!

BA