Empty space removal from excel cell

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.

Taidot: Excel, PHP, tietojärjestelmäarkkitehtuuri, VB.NET, Visual Basic

Näytä lisää: how do i use the trim function in excel?, how to remove space in excel after text, how to remove trailing spaces in excel, how to remove blank cells in excel, remove trailing spaces in excel trim not working, how to remove space in excel before numbers, how do you remove trailing spaces in excel?, how to remove space in excel cell at beginning, excel file number 1000 rows, vbnet excel value empty space, copy excel cell vbs, excel cell contents macro, copy excel cell selected, chart dynamic excel cell time stock data, excel cell copy, vbs move data excel cell internet explorer, copy excel cell contents windows application macro, vbs excel create xml file, create excel chart csv file, javascript excel cell copy paste

Tietoa työnantajasta:
( 41 arvostelua ) Byron Bay, Australia

Projektin tunnus: #15818497

Myönnetty käyttäjälle:


Dear, I can start now to create function to make email address as a result on column next to it. I don't have any work for this time, so i can spend all my time. I have completed some excel function project before, fee Lisää

$19 AUD 1 päivässä
(216 Arvostelua)

15 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

$30 AUD 1 päivässä
(248 arvostelua)

$30 AUD 1 päivässä
(249 arvostelua)

Hello Dear, I am an expert in Excel, PHP, Software Architecture, VB.NET, Visual Basic and I am really interested in your project. I am available to start working on it now. I work efficiently and will finish in a time Lisää

$30 AUD 0 päivässä
(188 arvostelua)

Need to remove the empty spaces from each row in the sheet Relevant Skills and Experience Excel Proposed Milestones $10 AUD - Work

$10 AUD 0 päivässä
(91 arvostelua)

Hi..having gone through your project description of getting email address from the text and putting into new column, I can help you in getting it done quickly and efficiently. Relevant Skills and Experience Technicall Lisää

$25 AUD 0 päivässä
(81 arvostelua)

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

$25 AUD 1 päivässä
(92 arvostelua)

Hello. I checked your excel file. ([login to view URL]) I can do your project in less than an hour according to your description with full delivery and without error. Relevant Skills and Experience I have extensive exp Lisää

$35 AUD 1 päivässä
(69 arvostelua)

Dear sir, I'm very interested for this project & I can surely do this project, I work with Team who always looking for such type of project, so please try to give me one chance. Relevant Skills and Experienc Lisää

$15 AUD 0 päivässä
(49 arvostelua)

I can help you to sperate the emails Relevant Skills and Experience great excel exp Proposed Milestones $15 AUD - excel work

$15 AUD 0 päivässä
(49 arvostelua)

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

$30 AUD 1 päivässä
(24 arvostelua)

We can make a VBA code that scans the first column and extract the e-mail info based on a certain pattern. Feel free to message me. Relevant Skills and Experience I have been using VBA code to find solution to a certa Lisää

$30 AUD 1 päivässä
(26 arvostelua)

Hello, I'm very much interested to help you working on this task you having right now. Relevant Skills and Experience I'm able to help you to start working on this task accurately as I have a lot experience with this Lisää

$30 AUD 1 päivässä
(22 arvostelua)
$50 AUD 4 päivässä
(5 arvostelua)

1 day delivery Relevant Skills and Experience excel, vb, macro creation Proposed Milestones $25 AUD - on delivery

$25 AUD 1 päivässä
(4 arvostelua)