| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
move from column f and g to column b, if filled
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
move from column f and g to column b, if filled
you mean to say combining F & G columns ? then use =F1&G1
On Oct 22, 1:46*am, ppeer wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
move from column f and g to column b, if filled
On 21 okt, 22:59, muddan madhu wrote:
you mean to say combining F & G columns ? then use =F1&G1 On Oct 22, 1:46*am, ppeer wrote: 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- Tekst uit oorspronkelijk bericht niet weergeven - - 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
move from column f and g to column b, if filled
On 21 okt, 22:59, muddan madhu wrote:
you mean to say combining F & G columns ? then use =F1&G1 On Oct 22, 1:46*am, ppeer wrote: 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- Tekst uit oorspronkelijk bericht niet weergeven - - 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
move from column f and g to column b, if filled
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. -- Don Guillett Microsoft MVP Excel SalesAid Software "ppeer" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| match values in column against another column and move | Excel Programming | |||
| how to move the cursor to column A after entering data column F | New Users to Excel | |||
| move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) | |||
| Last Filled Column | Excel Programming | |||
| Move Cell in Column A to Column B when FIND | Excel Programming | |||
Linear Mode
