We merged 2 columns together , but after we did alot of work we realized that
some cells are missing a few right charchters is there anyway to run a filter
& fix or mark those records seperatley

Well, there's ways to do all kinds of weird things in Excel, but we would
need more details in order to offer specific help for your case.

Vaya con Dios,
Chuck, CABGx3



"dk" wrote:

We merged 2 columns together , but after we did alot of work we realized that
some cells are missing a few right charchters is there anyway to run a filter
& fix or mark those records seperatley

ex: washington : Apt 51 ,was 2 cells merged the word apt but not the 5,
somtimes may be missing from the letter "t" from Apt till end of cell

"CLR" wrote:

Well, there's ways to do all kinds of weird things in Excel, but we would
need more details in order to offer specific help for your case.

Vaya con Dios,
Chuck, CABGx3



"dk" wrote:

We merged 2 columns together , but after we did alot of work we realized that
some cells are missing a few right charchters is there anyway to run a filter
& fix or mark those records seperatley

Did you really merge the cells? Have you looked up merge cells in help? It
clearly states that except for the upper leftmost cell's contents the rest
will be deleted. It even warns you when you are doing this:

"The selection contains multiple data values. Merging into one cell will
keep the upper-left most data only."

Of course if you concatenated as opposed to merge this won't happen, then it
is only a matter of making the column wider. If you really merged the cells
under formatcellsalignmentmerge cells then the error is between the chair
and the computer


--


Regards,


Peo Sjoblom



"dk" wrote in message
...
ex: washington : Apt 51 ,was 2 cells merged the word apt but not the 5,
somtimes may be missing from the letter "t" from Apt till end of cell

"CLR" wrote:

Well, there's ways to do all kinds of weird things in Excel, but we would
need more details in order to offer specific help for your case.

Vaya con Dios,
Chuck, CABGx3



"dk" wrote:

We merged 2 columns together , but after we did alot of work we
realized that
some cells are missing a few right charchters is there anyway to run a
filter
& fix or mark those records seperatley

were are not concerned how to merge now we would like the ones that merged
properly & the ones that didn"t

"Peo Sjoblom" wrote:

Did you really merge the cells? Have you looked up merge cells in help? It
clearly states that except for the upper leftmost cell's contents the rest
will be deleted. It even warns you when you are doing this:

"The selection contains multiple data values. Merging into one cell will
keep the upper-left most data only."

Of course if you concatenated as opposed to merge this won't happen, then it
is only a matter of making the column wider. If you really merged the cells
under formatcellsalignmentmerge cells then the error is between the chair
and the computer


--


Regards,


Peo Sjoblom



"dk" wrote in message
...
ex: washington : Apt 51 ,was 2 cells merged the word apt but not the 5,
somtimes may be missing from the letter "t" from Apt till end of cell

"CLR" wrote:

Well, there's ways to do all kinds of weird things in Excel, but we would
need more details in order to offer specific help for your case.

Vaya con Dios,
Chuck, CABGx3



"dk" wrote:

We merged 2 columns together , but after we did alot of work we
realized that
some cells are missing a few right charchters is there anyway to run a
filter
& fix or mark those records seperatley

Peo, ... I remember something from a few years ago, where you *could* merge
cells and still retain the contents of *all* the cells included within the
merge.

Don't remember who, when, or why, but it had to do with the "Format
Painter".

Just tried it out now, and I'll be damned, it *does work* on my XL02
machine!

Populate all 3 cells, A1:C1, with anything, text and/or numbers.


Select any 3 *other* cells in a row, and merge them the normal way,
<Format <Cell <Alignment tab, and click on "Merge".

Click in these merged cells and then click on "Format Painter".

Now, click on A1 to copy the merge format to those cells.

The merge displays normally, with only the contents of A1 being displayed.

With the A1:C1 merge selected, once again,
<Format <Cell <Alignment tab, and click on "Merge" to *de-select* it,
then <OK.

AND ... you'll see the original data displayed ... in all 3 cells ! ! !

Kind of weird, isn't it?

Would MS call this a "feature"?<bg

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------








"Peo Sjoblom" wrote in message
...
Did you really merge the cells? Have you looked up merge cells in help? It
clearly states that except for the upper leftmost cell's contents the rest
will be deleted. It even warns you when you are doing this:

"The selection contains multiple data values. Merging into one cell will
keep the upper-left most data only."

Of course if you concatenated as opposed to merge this won't happen, then it
is only a matter of making the column wider. If you really merged the cells
under formatcellsalignmentmerge cells then the error is between the chair
and the computer


--


Regards,


Peo Sjoblom



"dk" wrote in message
...
ex: washington : Apt 51 ,was 2 cells merged the word apt but not the 5,
somtimes may be missing from the letter "t" from Apt till end of cell

"CLR" wrote:

Well, there's ways to do all kinds of weird things in Excel, but we would
need more details in order to offer specific help for your case.

Vaya con Dios,
Chuck, CABGx3



"dk" wrote:

We merged 2 columns together , but after we did alot of work we
realized that
some cells are missing a few right charchters is there anyway to run a
filter
& fix or mark those records seperatley

David McRitchie was the first to post this feature--well, that I saw.

RagDyeR wrote:

Peo, ... I remember something from a few years ago, where you *could* merge
cells and still retain the contents of *all* the cells included within the
merge.

Don't remember who, when, or why, but it had to do with the "Format
Painter".

Just tried it out now, and I'll be damned, it *does work* on my XL02
machine!

Populate all 3 cells, A1:C1, with anything, text and/or numbers.

Select any 3 *other* cells in a row, and merge them the normal way,
<Format <Cell <Alignment tab, and click on "Merge".

Click in these merged cells and then click on "Format Painter".

Now, click on A1 to copy the merge format to those cells.

The merge displays normally, with only the contents of A1 being displayed.

With the A1:C1 merge selected, once again,
<Format <Cell <Alignment tab, and click on "Merge" to *de-select* it,
then <OK.

AND ... you'll see the original data displayed ... in all 3 cells ! ! !

Kind of weird, isn't it?

Would MS call this a "feature"?<bg

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Peo Sjoblom" wrote in message
...
Did you really merge the cells? Have you looked up merge cells in help? It
clearly states that except for the upper leftmost cell's contents the rest
will be deleted. It even warns you when you are doing this:

"The selection contains multiple data values. Merging into one cell will
keep the upper-left most data only."

Of course if you concatenated as opposed to merge this won't happen, then it
is only a matter of making the column wider. If you really merged the cells
under formatcellsalignmentmerge cells then the error is between the chair
and the computer

--

Regards,

Peo Sjoblom

"dk" wrote in message
...
ex: washington : Apt 51 ,was 2 cells merged the word apt but not the 5,
somtimes may be missing from the letter "t" from Apt till end of cell

"CLR" wrote:

Well, there's ways to do all kinds of weird things in Excel, but we would
need more details in order to offer specific help for your case.

Vaya con Dios,
Chuck, CABGx3



"dk" wrote:

We merged 2 columns together , but after we did alot of work we
realized that
some cells are missing a few right charchters is there anyway to run a
filter
& fix or mark those records seperatley

--

Dave Peterson

your are not anwering our question
we would to a filter for who not merged completly only partial both columns
are now text we would like to filter which are the differnt which are missing
please answer this nothing more

"RagDyeR" wrote:


Peo, ... I remember something from a few years ago, where you *could* merge
cells and still retain the contents of *all* the cells included within the
merge.

Don't remember who, when, or why, but it had to do with the "Format
Painter".

Just tried it out now, and I'll be damned, it *does work* on my XL02
machine!

Populate all 3 cells, A1:C1, with anything, text and/or numbers.


Select any 3 *other* cells in a row, and merge them the normal way,
<Format <Cell <Alignment tab, and click on "Merge".

Click in these merged cells and then click on "Format Painter".

Now, click on A1 to copy the merge format to those cells.

The merge displays normally, with only the contents of A1 being displayed.

With the A1:C1 merge selected, once again,
<Format <Cell <Alignment tab, and click on "Merge" to *de-select* it,
then <OK.

AND ... you'll see the original data displayed ... in all 3 cells ! ! !

Kind of weird, isn't it?

Would MS call this a "feature"?<bg

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------








"Peo Sjoblom" wrote in message
...
Did you really merge the cells? Have you looked up merge cells in help? It
clearly states that except for the upper leftmost cell's contents the rest
will be deleted. It even warns you when you are doing this:

"The selection contains multiple data values. Merging into one cell will
keep the upper-left most data only."

Of course if you concatenated as opposed to merge this won't happen, then it
is only a matter of making the column wider. If you really merged the cells
under formatcellsalignmentmerge cells then the error is between the chair
and the computer


--


Regards,


Peo Sjoblom



"dk" wrote in message
...
ex: washington : Apt 51 ,was 2 cells merged the word apt but not the 5,
somtimes may be missing from the letter "t" from Apt till end of cell

"CLR" wrote:

Well, there's ways to do all kinds of weird things in Excel, but we would
need more details in order to offer specific help for your case.

Vaya con Dios,
Chuck, CABGx3



"dk" wrote:

We merged 2 columns together , but after we did alot of work we
realized that
some cells are missing a few right charchters is there anyway to run a
filter
& fix or mark those records seperatley

That's one of the bad (or good!) things about having a discussion in a public
forum. You have no control of who posts what.

RagDyer was posting a reply to Peo--not directly to you or your posts. It may
be not be on point for your specific question, but it was interesting to RD and
maybe others.

dk wrote:

your are not anwering our question
we would to a filter for who not merged completly only partial both columns
are now text we would like to filter which are the differnt which are missing
please answer this nothing more

"RagDyeR" wrote:


Peo, ... I remember something from a few years ago, where you *could* merge
cells and still retain the contents of *all* the cells included within the
merge.

Don't remember who, when, or why, but it had to do with the "Format
Painter".

Just tried it out now, and I'll be damned, it *does work* on my XL02
machine!

Populate all 3 cells, A1:C1, with anything, text and/or numbers.


Select any 3 *other* cells in a row, and merge them the normal way,
<Format <Cell <Alignment tab, and click on "Merge".

Click in these merged cells and then click on "Format Painter".

Now, click on A1 to copy the merge format to those cells.

The merge displays normally, with only the contents of A1 being displayed.

With the A1:C1 merge selected, once again,
<Format <Cell <Alignment tab, and click on "Merge" to *de-select* it,
then <OK.

AND ... you'll see the original data displayed ... in all 3 cells ! ! !

Kind of weird, isn't it?

Would MS call this a "feature"?<bg

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------








"Peo Sjoblom" wrote in message
...
Did you really merge the cells? Have you looked up merge cells in help? It
clearly states that except for the upper leftmost cell's contents the rest
will be deleted. It even warns you when you are doing this:

"The selection contains multiple data values. Merging into one cell will
keep the upper-left most data only."

Of course if you concatenated as opposed to merge this won't happen, then it
is only a matter of making the column wider. If you really merged the cells
under formatcellsalignmentmerge cells then the error is between the chair
and the computer


--


Regards,


Peo Sjoblom



"dk" wrote in message
...
ex: washington : Apt 51 ,was 2 cells merged the word apt but not the 5,
somtimes may be missing from the letter "t" from Apt till end of cell

"CLR" wrote:

Well, there's ways to do all kinds of weird things in Excel, but we would
need more details in order to offer specific help for your case.

Vaya con Dios,
Chuck, CABGx3



"dk" wrote:

We merged 2 columns together , but after we did alot of work we
realized that
some cells are missing a few right charchters is there anyway to run a
filter
& fix or mark those records seperatley





--

Dave Peterson

dk

You have not answered Peo's question.

Were the cells "merged" using FormatCellsAlignmentMerge Cells?

Or were they "combined" using =CONCATENATE(A1,B1) or =A1&B1


Gord Dibben MS Excel MVP

On Mon, 31 Dec 2007 17:25:00 -0800, dk wrote:

your are not anwering our question
we would to a filter for who not merged completly only partial both columns
are now text we would like to filter which are the differnt which are missing
please answer this nothing more

"RagDyeR" wrote:


Peo, ... I remember something from a few years ago, where you *could* merge
cells and still retain the contents of *all* the cells included within the
merge.

Don't remember who, when, or why, but it had to do with the "Format
Painter".

Just tried it out now, and I'll be damned, it *does work* on my XL02
machine!

Populate all 3 cells, A1:C1, with anything, text and/or numbers.


Select any 3 *other* cells in a row, and merge them the normal way,
<Format <Cell <Alignment tab, and click on "Merge".

Click in these merged cells and then click on "Format Painter".

Now, click on A1 to copy the merge format to those cells.

The merge displays normally, with only the contents of A1 being displayed.

With the A1:C1 merge selected, once again,
<Format <Cell <Alignment tab, and click on "Merge" to *de-select* it,
then <OK.

AND ... you'll see the original data displayed ... in all 3 cells ! ! !

Kind of weird, isn't it?

Would MS call this a "feature"?<bg

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------








"Peo Sjoblom" wrote in message
...
Did you really merge the cells? Have you looked up merge cells in help? It
clearly states that except for the upper leftmost cell's contents the rest
will be deleted. It even warns you when you are doing this:

"The selection contains multiple data values. Merging into one cell will
keep the upper-left most data only."

Of course if you concatenated as opposed to merge this won't happen, then it
is only a matter of making the column wider. If you really merged the cells
under formatcellsalignmentmerge cells then the error is between the chair
and the computer


--


Regards,


Peo Sjoblom



"dk" wrote in message
...
ex: washington : Apt 51 ,was 2 cells merged the word apt but not the 5,
somtimes may be missing from the letter "t" from Apt till end of cell

"CLR" wrote:

Well, there's ways to do all kinds of weird things in Excel, but we would
need more details in order to offer specific help for your case.

Vaya con Dios,
Chuck, CABGx3



"dk" wrote:

We merged 2 columns together , but after we did alot of work we
realized that
some cells are missing a few right charchters is there anyway to run a
filter
& fix or mark those records seperatley

On Mon, 31 Dec 2007 17:25:00 -0800, dk wrote:

your are not anwering our question
we would to a filter for who not merged completly only partial both columns
are now text we would like to filter which are the differnt which are missing
please answer this nothing more

How about answering Peo's question so that you can be given an answer which is
pertinent? Otherwise you are just asking us to waste our time trying to figure
out how you did the merge.
--ron