Formula for extracting data from another cell

Closed
JAV - 30 Sep 2009 à 13:15
 atlas245 - 30 Oct 2009 à 00:52
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 14 June 2009 Status Contributor Last seen 7 August 2021 811
30 Sep 2009 à 20:56
highlight the cell containing the data
click
data(menu bar)-texttocolumns-delimited-next-check "other" and in the window type underscore(_)-click finish.
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.