I have a file with about 1000 rows. One of the cells has mixed data with empty spaces and one email address. I need a function, vb macro or anything similar to only have the email address as a result on the column next to it.
I attach example file with 2 records showing before and after.
I can not send the complete file because it has sensitive data (email addresses). You need to send me walk-through or solution i could use myself.
15 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
Hi, We have checked attach excel file and as per that we are able to do your work. Relevant Skills and Experience Excel Proposed Milestones $25 AUD - we will discuss later
Hello there, I would like to be considered for this job as I have great working experience in VB Macro development. Thanks, Ramesh Relevant Skills and Experience VBA, Excel Proposed Milestones $30 AUD - Initial