Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Apostrophe In Data Downloaded
I am importing into Excel a text file where one particular column has some
records with an apostrophe ("'") in front of them. Not all the records in that column have the apostrophe in front. The apostrophe acts as a formatting feature as it actually does not visually appear in the cell. Only by pressing F2 could one see that the apostrophe is there. (This is probably a quirk created by the ERP system where I get the data from.) How can I get rid of the apostrophe? I tried using the LEFT function and capturing everything starting from the second character, but it does not work... Thanks. -- tb |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
macro | Excel Discussion (Misc queries) | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) |