I have some Excel worksheet problem, Please help me?

Question

I copied some email id to excel worksheet now its look likes abcd@... or usaboy@... like that, how can i replace that to eg: [e-mail] or [e-mail], about 1500 email id i have, pls help me out

Answer 1

If your all emails are read half then you need to expand the column. Check the letter above the column, for example A, B, C etc. Place the cursor at the right on the margin of the column, then you will see a cross with two sided arrow, just click. It should expand all the columns to fit all the letters and characters for all emails. Or, you can drag the mouse right side of the column until you see all the email addresses are fitting in each cell. Or, select the column and click format > choose column> choose width> type the desired width that is 15, 28, 20 etc.>click ok. Any of the above suggestions should solve your problem. If it does not work, then select all text from original page again >click copy>paste. Then delete the ones are not pasted well.  

Answer 2

I get the same problem if I copy links from Y!A which are often shown shortened with three dots at the end.  I don't know where you're copying from, but I just tried copying an e-mail address from an e-mail to Excel and everything copied ok.  So I think the problem is caused by the source, not the copying process.

Are you able to contact the source(s) and ask them to send you a fresh, complete copy?  Alternatively, if you're able to separate the addresses on the worksheet into groups according to ISP (e.g. hotmail, msn etc), you could then highlight each group and press Ctrl+H to open the Replace facility.  Enter @ in the Find what field and @ plus the ISP in Replace with, then press Replace All.

Hope this helps

Answer 3

I could not understand your problem completely. Try selecting the column and then double-click/drag the column dividing line from the top of the sheet.

Answer 4

Do you need to expand the column width to see the entire content of the cell?

You can do that by dragging the right (as opposed to left) side of the cell at the top to expand.  Or alternatively, you could double click on that same divider and it would automatically resize to the longest cell content of the column.

Answer 5

Hmmm, maybe you copied all 1500 e-mail address into one box? Therefore they are compressed somewhat? If that isn't the problem, I'm sorry to say that maybe you would have to fix them one by one. :-/