| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numbers followed by space
I have a spreadsheet with about 2500 rows / 7 columns of numbers. The info
was pulled from another program and every one of the numbers has a space at the end so the formula isn't working. Is there anything I can do other than go cell by cell and delete the space? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numbers followed by space
This is worth a try
Copy a blank cell Select all the cells with the problem Use Edit | Paste Special with Add specified best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "malewis48" wrote in message ... I have a spreadsheet with about 2500 rows / 7 columns of numbers. The info was pulled from another program and every one of the numbers has a space at the end so the formula isn't working. Is there anything I can do other than go cell by cell and delete the space? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numbers followed by space
Your issue may be a bit larger than just that trailing space. Your data may
have been imported as text-- that is one reason for the training space. test a several of your cells with =isnumber(A2). If false you may be able to convert using a formula such as =value(A2) to convert the text in those 2500 rows of 7 columns. Be sure to replace teh A@ with an appropriate cell from your spreadsheet. HTH "malewis48" wrote: I have a spreadsheet with about 2500 rows / 7 columns of numbers. The info was pulled from another program and every one of the numbers has a space at the end so the formula isn't working. Is there anything I can do other than go cell by cell and delete the space? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numbers followed by space
=--LEFT(A1,LEN(A1)-1)
-- David Biddulph malewis48 wrote: I have a spreadsheet with about 2500 rows / 7 columns of numbers. The info was pulled from another program and every one of the numbers has a space at the end so the formula isn't working. Is there anything I can do other than go cell by cell and delete the space? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numbers followed by space
Select the range to fix
Edit|replace what: (space character) with: (leave blank) replace all malewis48 wrote: I have a spreadsheet with about 2500 rows / 7 columns of numbers. The info was pulled from another program and every one of the numbers has a space at the end so the formula isn't working. Is there anything I can do other than go cell by cell and delete the space? -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Numbers followed by space
Select the range to fix
Edit|replace what: ALT+0160 with: (leave blank) replace all Note: While Enter 0160 in find what Hold the ALT KEY "malewis48" wrote: I have a spreadsheet with about 2500 rows / 7 columns of numbers. The info was pulled from another program and every one of the numbers has a space at the end so the formula isn't working. Is there anything I can do other than go cell by cell and delete the space? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - Allow numbers, comma, - and space | Excel Discussion (Misc queries) | |||
| How can I remove a space between a letters and set of numbers? | Excel Discussion (Misc queries) | |||
| How do I write a script to add space between numbers in a column? | Excel Discussion (Misc queries) | |||
| Extra space after imported numbers | Excel Discussion (Misc queries) | |||
| Space between decimal numbers | Excel Worksheet Functions | |||
Linear Mode
