need help???

[adam]

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!!!

 

[FSt1]

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

 

[Ron Rosenfeld]

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

 

[FSt1]

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

regards
FSt1