how to merge two colums?
one contains text rows
the other contains numeric data
without loosing any of the data
this means merging the data also
thanks for your help
how to merge two colums?
one contains text rows
the other contains numeric data
without loosing any of the data
this means merging the data also
thanks for your help
Try Debra's nice coverage at her:
http://www.contextures.com/xlCombine01.html
She also provides some examples of how to format the numeric data part when
it's combined with text under the "Formatting Examples" section - scroll
down towards the end of the page
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"wimmat" <[email protected]> wrote in message
news:[email protected]...
> how to merge two colums?
> one contains text rows
> the other contains numeric data
> without loosing any of the data
> this means merging the data also
>
> thanks for your help
Put this formula in a third column:
=CELL1&" "&CELL2
Where CELL1 = the first cell you want to merge, eg A1 and CELL2 = the second
cell, eg B1 - NB there is a space between the "s
Hope that makes sense
Jess
"wimmat" wrote:
> how to merge two colums?
> one contains text rows
> the other contains numeric data
> without loosing any of the data
> this means merging the data also
>
> thanks for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks