1.
if i have a sheet where some of it has data from a diff sheet using a formula
how can i actually copy the whole table with data only and not the formula
so i wont need to rely on the other sheets.

2. if i have 2 column2 lets say Address1 address2 how can i merge those 2 on
every row? it is important that when it merges it will place a space between
the merged data so it one be one word.

Thank you!!!

hi
1. copying something assumes that your going to pasted it somewhere. when
you paste, paste special as values. this way the the formula will turn into
hard data.
2.assuming data is in column A and B....use this formula in Column C...
= A2 & " "& B2.
Copy column C and pastes special as values in Colunm C. see 1 above.
Delete Columns A and B. (or archive if needed)

Regards
FSt1

"adam" wrote:


1.
if i have a sheet where some of it has data from a diff sheet using a formula
how can i actually copy the whole table with data only and not the formula
so i wont need to rely on the other sheets.

2. if i have 2 column2 lets say Address1 address2 how can i merge those 2 on
every row? it is important that when it merges it will place a space between
the merged data so it one be one word.

Thank you!!!

On Tue, 11 Mar 2008 11:50:08 -0700, FSt1
wrote:

2.assuming data is in column A and B....use this formula in Column C...
= A2 & " "& B2.

I would suggest

=TRIM(A2 & " " & B2)

in case there is nothing in B2

--ron

hi
good idea. i didn't think of that.

regards
FSt1

"Ron Rosenfeld" wrote:

On Tue, 11 Mar 2008 11:50:08 -0700, FSt1
wrote:

2.assuming data is in column A and B....use this formula in Column C...
= A2 & " "& B2.

I would suggest

=TRIM(A2 & " " & B2)

in case there is nothing in B2

--ron