Devam Ediyor

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ün: 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

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

Proje NO: #64254

Seçilen:

kit1980

I will make such xls file

2 gün içinde 30$ USD
(1 Değerlendirme)
1.8

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

montir

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

1 gün içinde 40$ USD
(1 Değerlendirme)
1.2
dustymonk

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

1 gün içinde 80$ USD
(0 Değerlendirme)
0.0