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 |
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) |