Helpppp

[advantafaxgirrl]

ok...i just used the concatenate function to merge two cells of inf
together into one...worked great until i tried ot copy and paste th
merged info onto another worksheet...i NEED the merged info to show up
it shows as if there is nothing there at all. I only see the functio
in the formula bar. Just to let everyone know...i had a list of phon
numbers (area code and number) in one cells and needed to add a on
before some. I used the function and i see the 13055556666 and only th
formula in the bar at the top. When i copy and try to paste the entir
number it shows up blank on another worksheet...ahhhh!!!!

is there a fix to this?

Annett

 

[Kieran]

Annette,

When you paste the data, use paste special instead of standard past
and specify the 'values' option

 

[advantafaxgirrl]

thanks so much...ur the best!