Never saw this before - What is it?

[Dennisr53]

Hi Everyone,

I recently downloaded some data from Medi Tech and received the following date information. I have never seen the icon in front of the date. What is it? I cannot click on it or drill down into the date but it does not allow me to use the date as a date.

it appears to be a text box with a ? in it but, it will not copy it. When I copy the cell it only gives me the date.

Sorry I cannot show it to you but I can't seem to snag it.

Thanks,
Dennis

 

[MARK858]

do the same again as before and make sure the "match entire cell contents" isn't checked... what happens?

 

[Dennisr53]

"Excel has completed its search and has made 5 replacements." Nothing has changed on the spreadsheet though.

Put the code in and still get 12

 

[MARK858]

Select the column then put the code below in a regular module (ALT F11 , click Insert, click module, copy the code below into the white space).

Put your cursor anywhere in the code and press F5.

Any good?

Sub RepIt()
 Selection.Replace What:=Chr(12), Replacement:="", LookAt:=xlPart
End Sub

 

[Dennisr53]

Mark858,

Thank you very much it corrected the issue.

Thanks for sticking with me through this. I really appreciate it.

Dennis

 

[MARK858]

Your welcome

 

[Smitty]

I am a fairly new member. Can you tell me how to do that as I do not see that feature anywhere.

Click on a member's name and you'll see the Private Message option listed.