Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
=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 | |
|
|
![]() |
||||
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) |