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

[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

 

[muddan madhu]

you mean to say combining F & G columns ? then use =F1&G1

 

[ppeer]

you mean to say combining F & G columns ? then use =F1&G1





- Tekst uit oorspronkelijk bericht weergeven -

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

 

[ppeer]

you mean to say combining F & G columns ? then use =F1&G1





- Tekst uit oorspronkelijk bericht weergeven -

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

 

[Don Guillett]

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.