Formula Check Request

Topic

New Reply

Hi guys,
The attached workbook has some formulas (columns highlighted in blue). One is wrong (Column C). Another one is probably not the most optimal solution (Column I).

The unhighlighted columns represents data that I receive from an export. The highlighted columns are helping me to make the data more usable.

=DATEVALUE(TEXT(((MID(H2,1,(LEN(H2)-1-LEN(RIGHT(H2,FIND(” “,H2))))))&”, “&(RIGHT(H2,FIND(” “,H2)))),”dd-mmm-yy”))

An help in correcting and validating is always appreciated.

Thanks
Amy

Reply | Quote

Replies

In C2 you can something like
=RIGHT(A2,LEN(A2)-FIND(“,”,A2)-1)
or
=TRIM(MID(A2,FIND(“,”,A2)+1,LEN(A2)))

Find counts from the left not the right…

in I2
=DATEVALUE(SUBSTITUTE(H2,” “,”, “,2))

Steve

Reply | Quote

Steve,
This worked great. Thank you.

Amy

Reply | Quote