Sedang Disiapkan

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.

Kemahiran: Visual Basic

Lihat lebih lanjut: simple excel project, starting visual basic, creating simple excel project, n excel, a3, a1, simple macro, simple excel, manipulate, macro excel, j1, find project, cells, trying, excel macro row, project macro, excel cell, project example, text row, find excel project, excel fill, excel text columns, simple text excel, excel macro simple, simple project example

Tentang Majikan:
( 1 ulasan ) Portsmouth, United Kingdom

ID Projek: #64254

Dianugerahkan kepada:

kit1980

I will make such xls file

$30 USD dalam 2 hari
(1 Ulasan)
1.8

3 pekerja bebas membida secara purata $50 untuk pekerjaan ini

montir

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

$40 USD dalam sehari
(1 Ulasan)
1.2
dustymonk

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

$80 USD dalam sehari
(0 Ulasan)
0.0