Help adding text to a column during a marco recording

Hi there,

Assuming your 'Category details' refer the the first part of the value in column A (after the 4 digit number to the column ':').

Try this code:

Please Login or Register  to view this content.

Wow thanks so much for the time you spent on this. This is nearly perfect. The one thing though is that I actually want 'Category Details' written in column F regardless of whats written in column A, thats it so no need to copy any of that at all just have Category details display as long as theres something, anything at all in column A. The other macro piece looks wonderful! Any chance you can help me with that? I was wondering if maybe it would be somethign like this (after looking at your code):

Split out the category name from column A
If InStr(Range("A" & i), ":") > 0 Then
Range("F" & i).Value = "Category Details"
End If

Also I wonder if the ":" could be replaced with a "*" to pick anything up. The ":" probably will work anyhow but what is used for any character?

Best


Scott

Hi Scott,

Thanks for your feedback.
Just writing 'Category Details' makes it simpler.

Try the below.

Please Login or Register  to view this content.