move from column f and g to column b, if filled

  • Thread starter Thread starter ppeer
  • Start date Start date
P

ppeer

Hi Expert,

I have filled and blank cells in columns F and G.
Columns B:E are blank. A is filled.
I would like to put the F and G cells, if filled, to column B.
Any suggestions?

Now:

b g
b g
b
b g
bf
b
bf
bf

Desired:
bg
bg
b
bg
bf
b
bf
bf
 
you mean to say combining F & G columns ? then use =F1&G1





- Tekst uit oorspronkelijk bericht weergeven -
Click to expand...

No not exactly,
It is a two cell content, beginning in column f or g.
e.g.
name (row, column f) adress (row, column g) or:
name (row, column g) adress (row, column h)

I would like to keep the cells seperated when I move them to column b,
same row (so column c will also be filled).

best regards,
Peter
 
you mean to say combining F & G columns ? then use =F1&G1





- Tekst uit oorspronkelijk bericht weergeven -
Click to expand...

like:

Now:


b gg
b gg
b
b gg
b ff
b
b ff
b ff


Desired:
bgg
bgg
b
bgg
bff
b
bff
bff
 
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.
 
Back
Top