CUT AND PASTE (FORMULA WITH CONCATENATE)?

[rhwebb]

Need some help from the VBA gurus please. I'm working on a project (simplified here) in which I need to remove the text in cell F2:J2 (merged). The data within that cell will then be placed into cell A3:J3 (merged). However I do not need the entire text/date string-- only "Report Date: dd - mmm - yyyy". I'm looking either for a VBA solution to cut and paste which will isolate that text string (variable date) or a formula to CONCATENATE "Report Date:" with Today(). When I tried to write an ActiveCell.FormulaR1C1= i received an error for expected end. Would really appreciate any help.

Thanks

 

[rhwebb]

Okay, using our original problem set. If F2 was “Source Database: Report Date: 17 Jan 2022 11:55 p.m.“ but I only want to keep “ Report Date:17 Jan 2022”. That’s feasible? Really cool. I need to do some studying! Thank you for sharing your knowledge!

 

[Peter_SSs]

If F2 is always that format then something like this should do it.

Range("A3").Value = Trim(Mid(Range("F2").Value, 18, 24))

 

[rhwebb]

If F2 is always that format then something like this should do it.

Range("A3").Value = Trim(Mid(Range("F2").Value, 18, 24))

Yes! That works perfectly! Thank you so much for the assistance. Showed the final product to the boss and he's happy and we save tons of time now!

 

[Peter_SSs]

Good news! Thanks for the follow-up.
You are welcome.