Hello,
I am trying to develop a formula that will extract data from a cell that has data in the below format
'VRG-F-119-Ground Floor _18-Sep-2009_01.56.25--01.57.31_001.nvf'
I am trying to breakout that data in different columns so that it can be put into a pivot table format for analysis.
i.e. date '18-Sep-2009' would be one column breakout, 'VRG-F-119-Ground Floor' would be another breakout.
with the '_'in between all the data I don't know how to get Excel to register the data as separate sections.
If you have any suggestions, thank you for your help
Configuration: Windows XP Internet Explorer 8.0
I agree with above also check http://www.extractingdata.com for help
|
Excel formula compare give data next to cell if true Excel formula copy contents down if cell blank Excel formula select colour cell Excel formula to compare cell to range Extract data from excel file to another excel file Extract data from raw excel spreadsheet Extracting certain rows of data to another excel sheet How do you type a formula that will add the contents of a cell on one worksheet and another cell on a different worksheet in exc How to make a formula to colour a cell according to their value in excel If one cell equals yes then apply data validation In excel 2007 how can extract data from one sheet to another In excel i want a formula that will automatically turn a number negative or positive depending on the data validation Input value and formula in same cell Insert formula if another cell contains a value vba Multiple data lines in cell Raw data cell range box excel Replace list of cell number in formula Vba apply a formula to a cell