I gang

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.

Færdigheder: Visual Basic

Se mere: 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

Om arbejdsgiveren:
( 1 bedømmelse ) Portsmouth, United Kingdom

Projekt-ID: #64254

Tildelt til:

kit1980

I will make such xls file

$30 USD in 2 dage
(1 bedømmelse)
1.8

3 freelancere byder i gennemsnit $50 for dette job

montir

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

$40 USD på 1 dag
(1 bedømmelse)
1.2
dustymonk

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

$80 USD på 1 dag
(0 bedømmelser)
0.0