simple excel project

I want to manipulate text in excel. The text is broken down to cells, each row has up to 8 cells (columns A to H), including blank cells. I am trying to find a macro that will fill the 9th cell in each row with the last cell on the same row excluding the blank cells.

For example:

starting from A1, if row 1 (each [] represents a cell) =

[21][Brook Close][SO12 1SP][][][][][][] then I want in cell J1 to get the text from cell A3 .

However if row 2 =

[2][Rose rd][Bitterne Park][Bitterne][Soton][HANTS][SO18 1PS][][] then in cell J2 I want to get the text from G2.

The blanks are always at the end of each row.

Beceriler: Visual Basic

Daha fazlasını gör: simple excel project, starting with visual basic, excel &, creating simple excel project, n excel, A3, a1, simple macro, simple excel, manipulate , macro excel, macro + excel, j1, find project, excel\ , excel, excel project, excel project 2/2, excel c#, end project, cells, trying, excel macro row, project macro, excel cell

İşveren Hakkında:
( 1 değerlendirme ) Portsmouth, United Kingdom

Proje NO: #64254



I will make such xls file

%selectedBids___i_period_sub_7% gün içinde 30%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(1 Yorum)

Bu iş için 3 freelancer ortalamada $50 teklif veriyor


Let me try with it.. i have some experience in excel formula...

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)

Hi! I'll do it in 1 day for 80 bucks. Contact me now and get your job done!

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)