| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting this raw data into something formulaic
Rick,
Nice one '--- Jim Cone "Rick Rothstein" wrote in message ... Hi Jim, thanks for your reply. It's actually just purely text. There's absolutely nothing behind it right now unfortunately. Assuming you do not have to convert that date/time to another time zone, select the entire column (or column) of dates, press CTRL+H to bring up the Replace dialog box, type this... " PST*" (without the quote marks)(notice the leading space) into the "Find what" field and make sure the "Replace with" field is completely empty, then press the "Options" button and make sure the "Match entire cell contents" checkbox is NOT checked, then click the "Replace All" button and your values should all get changed to real time/date values (which you can "cell format" to look however you want). Rick Rothstein (MVP - Excel) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting daily data into weekly, monthly and yearly data | Excel Discussion (Misc queries) | |||
| Converting Vertical Data into Horizontal Data | Excel Discussion (Misc queries) | |||
| Formulaic range with CountIf | Excel Worksheet Functions | |||
| Reformattign Data/Converting-Combinign Vertical Data to Horizontal | Excel Worksheet Functions | |||
| converting continuous data into binary data | Excel Worksheet Functions | |||
![Jim Cone[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
