For each row in excel activity, a particular row has an email address that gets copied into a different excel sheet, the original excel cell with the email is formatted as text but it appears in a blue font cell in the new excel workbook.
Plus every other row that gets copied after this email address cell also gets a blue font even though they are not email addresses.
Ive formatted both workbooks as text/general but gave up…HELP !!!
FUC#######################
Sorry guys, my bad lol.
I found if you have the excel files within your project folder the cells get copied as plain text.
Note to self : Read the FU##ING Manual !!!