|
Ignorning #NAME? error
i have data cells that look similiar to this: - Jack Nap - Steve Lee and excel replaces those text with #NAME? (invalid error name). im assuming its doing this because of the - sign in front of the name. is there a way i can force excel to ignore the error and show the text? thanks in advance. -- spr1nt ------------------------------------------------------------------------ spr1nt's Profile: http://www.excelforum.com/member.php...o&userid=33528 View this thread: http://www.excelforum.com/showthread...hreadid=533212 |
Ignorning #NAME? error
Try putting an apostrophe (single quote) in front to signify text, e.g. '- Jack Nap or you could preformat your cells as text, then you can just enter - Jack Nap -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=533212 |
Ignorning #NAME? error
Hi there,
you're right, it's because the - sign. to avoid it, either you can start the content of the cell with shift+1 (which is: ' ) then the excel does not think, you are going to give formulas in it, then stops calculating or you select the desired range of cells and a) right click/Format Cells or b) Format menu/Format Cells in both cases select the Number sheet and set the format to Text and then you can add the requiered texts in both cases you tell Excel that you are not using formulas NB. in case later on you want formulas in the formatted cells, then you should do the other way aroind, to have active formulas... Best regards, ANdras (Hungary) "spr1nt" wrote: i have data cells that look similiar to this: - Jack Nap - Steve Lee and excel replaces those text with #NAME? (invalid error name). im assuming its doing this because of the - sign in front of the name. is there a way i can force excel to ignore the error and show the text? thanks in advance. -- spr1nt ------------------------------------------------------------------------ spr1nt's Profile: http://www.excelforum.com/member.php...o&userid=33528 View this thread: http://www.excelforum.com/showthread...hreadid=533212 |
Ignorning #NAME? error
thanks for the help guys. i have a couple more questions im hoping you can help me out with. is there a way to make excel treat everything as a text before loading a file? right now i have to fix every single cell with the error after opening the file. i also tried selecting the whole column with the errors and choosing format cells -- text hoping that it would change the #NAME? to the correct text but this didnt work. am i doing something wrong or is this not possible? -- spr1nt ------------------------------------------------------------------------ spr1nt's Profile: http://www.excelforum.com/member.php...o&userid=33528 View this thread: http://www.excelforum.com/showthread...hreadid=533212 |
Ignorning #NAME? error
If you're opening a text file, make sure the file does not have an extension of
..csv (use .txt). Then when you do File|Open, you'll be presented with the text to columns wizard. You can choose text for each field you want. spr1nt wrote: thanks for the help guys. i have a couple more questions im hoping you can help me out with. is there a way to make excel treat everything as a text before loading a file? right now i have to fix every single cell with the error after opening the file. i also tried selecting the whole column with the errors and choosing format cells -- text hoping that it would change the #NAME? to the correct text but this didnt work. am i doing something wrong or is this not possible? -- spr1nt ------------------------------------------------------------------------ spr1nt's Profile: http://www.excelforum.com/member.php...o&userid=33528 View this thread: http://www.excelforum.com/showthread...hreadid=533212 -- Dave Peterson |
| All times are GMT +1. The time now is 04:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com