S semry Registered User. Local time Today, 07:08 Joined Aug 5, 2012 Messages 22 Aug 23, 2012 #1 I get a Excel report each month with a cell that contains "01/01/12-01/08/12". Is there a way to add this into a table and split it into two different fields(From, To)?
I get a Excel report each month with a cell that contains "01/01/12-01/08/12". Is there a way to add this into a table and split it into two different fields(From, To)?
pbaldy Wino Moderator Staff member Local time Today, 07:08 Joined Aug 30, 2003 Messages 36,270 Aug 23, 2012 #2 If the structure is reliable, you can use the Mid() function to grab each portion.
