Hello.

I don't normally use Excel or any spreadsheets but need to convert
some XLS data into a dbf format. Problem is that some of the info in
the spreadsheet runs over a couple cells and I want to be able to copy
those 3 sells into ONE data file MEMO field. How do I combine these
together without having to retype all the text into one cell.

BTW, I can Email you a small XLS to illustrate what I mean as if you
can understand my ? you are a EXCEL GURU.

Thanks.

DeWayne
dchiass(at)telus(dot)net

Use a formula like this

=A1&" "&B1" "&C1

replace with your cell refs, then copy down and copy and paste special as
values,
finally delete the original data

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello.
>
> I don't normally use Excel or any spreadsheets but need to convert
> some XLS data into a dbf format. Problem is that some of the info in
> the spreadsheet runs over a couple cells and I want to be able to copy
> those 3 sells into ONE data file MEMO field. How do I combine these
> together without having to retype all the text into one cell.
>
> BTW, I can Email you a small XLS to illustrate what I mean as if you
> can understand my ? you are a EXCEL GURU.
>
> Thanks.
>
> DeWayne
> dchiass(at)telus(dot)net