Formula for extracting data from another cell

Closed
JAV - Sep 30, 2009 at 01:15 PM
 atlas245 - Oct 30, 2009 at 12:52 AM
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

2 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 30, 2009 at 08:56 PM
highlight the cell containing the data
click
data(menu bar)-texttocolumns-delimited-next-check "other" and in the window type underscore(_)-click finish.
4
i agree with above also check https://www.extractingdata.com/ for help
but basically
Highlight the cell
click
data(menu bar)-texttocolumns-delimited-next-check "other" and in the window type underscore(_)-click finish.
1