Re: $$Excel-Macros$$ Split column data by formula

All of your values can be extracted with string functions like:LEFT(A3,6) MID(A3,7,6) DATEVALUE(MID(A3,13,11)) MID(A3,24,2) MID(A3,26,20)  But if future values are not in the same format, these functions may not work. Paul- “Do all the good you can, By all th

$$Excel-Macros$$ Split column data by formula

Dear Sir Formula to split data as per column coloured Yellow. -- *Rajesh Kumar Agarwal* *9811063001* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RUL