Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Working with data?
Hi, I got some data from somewhere , all the numbers has (m) in the end ,for
example: 123(m) , 234(m), 456(m),...I wanna delete (m) from the end of all to use them in my calculations.Any suggestion? |
#2
|
|||
|
|||
Working with data?
FF
If they are truly in brackets then you could do a replace (EditReplace) and then use (m) in the 'what' box and nothing in the 'replace with' box -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "FF" wrote in message ... Hi, I got some data from somewhere , all the numbers has (m) in the end ,for example: 123(m) , 234(m), 456(m),...I wanna delete (m) from the end of all to use them in my calculations.Any suggestion? |
#3
|
|||
|
|||
Working with data?
"FF" wrote: Hi, I got some data from somewhere , all the numbers has (m) in the end ,for example: 123(m) , 234(m), 456(m),...I wanna delete (m) from the end of all to use them in my calculations.Any suggestion? Try using the find / replace function under the edit tab. find (m) replace (leave blank) |
#4
|
|||
|
|||
Working with data?
FF wrote:
I got some data from somewhere , all the numbers has (m) in the end ,for example: 123(m) , 234(m), 456(m). I wanna delete (m) from the end of all to use them in my calculations.Any suggestion? Depends on what you mean by "somewhere". If you can put the data into a txt file (Notepad), then in Excel go to Data Import External Data Import Data, open your txt file, and select Delimited Other using "(". That will break the data into two columns, the latter having "m)". You should be able to import just the column with the numeric data. But Excel 2003 always seems to import both columns, even when I highlight only the one. You can delete the column with "m)" after importing, if necessary. If the strings are already in an Excel column, you can do something similar by using the Date Text to Columns feature. |
#5
|
|||
|
|||
Working with data?
Assuming your first piect of text, "123(m)", is in cell A1, use this formula
in a nearby cell, such as B1, and copy down. =VALUE(SUBSTITUTE(A1,"(m)","")) "FF" wrote: Hi, I got some data from somewhere , all the numbers has (m) in the end ,for example: 123(m) , 234(m), 456(m),...I wanna delete (m) from the end of all to use them in my calculations.Any suggestion? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
How do I import formmail data to a custom excel template? | Excel Worksheet Functions | |||
Data Connection wizard quits working | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |