| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove a character from a number field
Im working with a column of various hh:mm data. Example of data:
29.28h 344.25h 26.75h 7.25h 0h 12.5h 0h 14.5h 13.25h As you can see, there is no fixed decimal place. Does any one know how I may be able to move the h from the end of the numbers for the column? Thanks in advance, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove a character from a number field
Try this and drag down
=LEFT(A1,LEN(A1)-1)*1 Mike "Taj" wrote: Im working with a column of various hh:mm data. Example of data: 29.28h 344.25h 26.75h 7.25h 0h 12.5h 0h 14.5h 13.25h As you can see, there is no fixed decimal place. Does any one know how I may be able to move the h from the end of the numbers for the column? Thanks in advance, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove a character from a number field
hi
the simplest and easiest way might be to use find and replace. high light the column then ctrl+F click the replace tab find what:= h replace with:= leave blank click replace all regards FSt1 "Taj" wrote: Im working with a column of various hh:mm data. Example of data: 29.28h 344.25h 26.75h 7.25h 0h 12.5h 0h 14.5h 13.25h As you can see, there is no fixed decimal place. Does any one know how I may be able to move the h from the end of the numbers for the column? Thanks in advance, |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove a character from a number field
Edit/ replace/ h/ with /(nothing)
-- David Biddulph "Taj" wrote in message ... I'm working with a column of various hh:mm data. Example of data: 29.28h 344.25h 26.75h 7.25h 0h 12.5h 0h 14.5h 13.25h As you can see, there is no fixed decimal place. Does any one know how I may be able to move the 'h' from the end of the numbers for the column? Thanks in advance, |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Remove a character from a number field
Hey thanks guys, you've saved me a great deal of time
"David Biddulph" wrote: Edit/ replace/ h/ with /(nothing) -- David Biddulph "Taj" wrote in message ... I'm working with a column of various hh:mm data. Example of data: 29.28h 344.25h 26.75h 7.25h 0h 12.5h 0h 14.5h 13.25h As you can see, there is no fixed decimal place. Does any one know how I may be able to move the 'h' from the end of the numbers for the column? Thanks in advance, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to add character before leading zero in a field | Excel Discussion (Misc queries) | |||
| remove cr character from a + number and change number to - 159cr | Excel Worksheet Functions | |||
| removing character from field | Excel Worksheet Functions | |||
| Field Character Changes | Setting up and Configuration of Excel | |||
| 15 character field truncating | Excel Discussion (Misc queries) | |||
Hybrid Mode
