Stupid Question

[o5prey]

I can't find the command that will allow me to take the value from a cell, text and a date combined and then just leave the date. The text value is always the same 13 characters that preceed the date.

Sorry just can't find the command been awhile since I used it.

[VBA Noob]

Hi,

Without seeing a example I'm sure there's a few ways to do this.

e.g

if the Text and date are separated by a space you could use Data > Text to Column > Delimiter > space.

or
say your data is abcdefghijklm (13 characters) you could try the below. Replace my data for yours

=VALUE(TRIM(SUBSTITUTE(A1,"abcdefghijklm","")))
formatted as date

or

=VALUE(RIGHT(A1,LEN(A1)-14))
formatted as date


VBA Noob