| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing parts of Data in a Cell / [], #
I have date that is copied from another program (similar to notebook) and
pasted into excel. I perform text to colums and end up with ALMOST whta I need. The problem is that two colums are not exactly right. One colum shows four digit numbers with brackets [1234]. I need to keep the number, but remove the brackets. The second column has a string of numbers with #in front #12345678. I need to keep the number string, but remove the # symbol. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing parts of Data in a Cell / [], #
Use "Edit", "Replace" (and leave Replace with blank)
-- If my posting was helpful, please click the "Yes" button. ROCK ON!, Scott "Teddy-B" wrote: I have date that is copied from another program (similar to notebook) and pasted into excel. I perform text to colums and end up with ALMOST whta I need. The problem is that two colums are not exactly right. One colum shows four digit numbers with brackets [1234]. I need to keep the number, but remove the brackets. The second column has a string of numbers with #in front #12345678. I need to keep the number string, but remove the # symbol. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing parts of Data in a Cell / [], #
=MID(A2,2,LEN(A2)-2) for the first
=RIGHT(A2,LEN(A2)-1) for the second -- David Biddulph "Teddy-B" wrote in message ... I have date that is copied from another program (similar to notebook) and pasted into excel. I perform text to colums and end up with ALMOST whta I need. The problem is that two colums are not exactly right. One colum shows four digit numbers with brackets [1234]. I need to keep the number, but remove the brackets. The second column has a string of numbers with #in front #12345678. I need to keep the number string, but remove the # symbol. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I only Want the Data from certain parts of the col. to be returned | Excel Worksheet Functions | |||
| removing date data from a cell | Excel Discussion (Misc queries) | |||
| Removing a blank cell between data | New Users to Excel | |||
| Removing data from cell within an excel spreadsheet | Excel Discussion (Misc queries) | |||
| Removing only certain data in a cell | Excel Discussion (Misc queries) | |||
Linear Mode
