could it be as easy as =cn1 & " " & cn2

--
Don Guillett
SalesAid Software

"grady88" wrote in message
...
I am working with excel and dealing with multiple spreadsheets. I am
configuring data for By Company Total, then into By Rep Total and now into
By
Region Total. I have a region called CN. Within CN are are two reps and I
need to combine their data into one CN instead of CN1 and CN2. I am unsure
as
to how to do this without messing up all the other data. I started to work
on
it, but I think my way will take way too long and I figure there has got
to
be an easier way. Could someone please assist me?