Formula for extracting data from another cell

Closed
Report
-
 atlas245 -
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 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
highlight the cell containing the data
click
data(menu bar)-texttocolumns-delimited-next-check "other" and in the window type underscore(_)-click finish.
4
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

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.