Merge Multiple Cells

I have a column of multiple numbers and I need to merge the duplicated
numbers into just one cell. Is there a formula that I can write to tell
Excel to merge the cells with the same numbers? Here is an example:

105
105
105
113
114
114
115
115

Assume you mean lose the duplicates as opposed to merging.

If so then try Data / Filter / Advanced Filter, tick 'Copy To another
location' and choose 'Unique values only'

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Carter68" <[email protected]> wrote in message
news:[email protected]...
>I have a column of multiple numbers and I need to merge the duplicated
> numbers into just one cell. Is there a formula that I can write to tell
> Excel to merge the cells with the same numbers? Here is an example:
>
> 105
> 105
> 105
> 113
> 114
> 114
> 115
> 115
>

I am needing to merge the data in Column A but I do not want to merge the
data in Columns B, Columns C, etc.

Column A Column B Column C
105 Sherry Acct #
105 Sherry Acct #
105 Sherry Acct #
110 John Acct #
110 John
114 Sue
118 Bob
118 Bob
118 Bob Acct #

When I am done merging, it should look like this:

Column A Column B Column C
105 Sherry Acct #
Sherry Acct #
Sherry Acct #
110 John Acct #
John
114 Sue
118 Bob
Bob
Bob Acct #

I appreciate any help you can provide.

Thanks!

"Ken Wright" wrote:

> Assume you mean lose the duplicates as opposed to merging.
>
> If so then try Data / Filter / Advanced Filter, tick 'Copy To another
> location' and choose 'Unique values only'
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ------------------------------Â*------------------------------Â*----------------
> It's easier to beg forgiveness than ask permission :-)
> ------------------------------Â*------------------------------Â*----------------
>
>
> "Carter68" <[email protected]> wrote in message
> news:[email protected]...
> >I have a column of multiple numbers and I need to merge the duplicated
> > numbers into just one cell. Is there a formula that I can write to tell
> > Excel to merge the cells with the same numbers? Here is an example:
> >
> > 105
> > 105
> > 105
> > 113
> > 114
> > 114
> > 115
> > 115
> >
>
>
>