ive just used the trim function, i then tried to copy the trimmed column and paste it into a new column on a new page, and got #REF i cant seem to get it to display the text, pls help
Posts by bruno
Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.
-
-
Just to say thanks to ROYUK.
i managed to do what i wanted, on the systransoft site, it was for a assignment for my son, who hates french, i know its cheating but he can't get to grips with the subject, it made it so easy.
to anyone else who is wanting to translate text, there are loads of languages on the site to convert to, you can enter upto 150 words, it will then translate immediately.
again thanks for your help
-
In your document, click file, then page setup, select landscape, then on your document click format then columns then select two
-
Thank you for your replies, i will look into grahams point, if i fail there i will look for the software, either way i will let you know how i get on...again thanks:guitar:
-
Is it possible to convert the text in a story ive written in word, from english to french?
or is there any software that can do this?
-
please rephrase the question:smug:
-
i dont know what VBA is, but i copy from excel to text then from text to word, then i select 2 columns giving me equivalent to 2 pages of excel to 1 page in word.
i also understand that my point may mean nothing
but i just wanted to reply to something :bsmile:
-
ive tried denis's version and it works fine, however can it be done by just removing the column headers and leaving the numbered rows?
-
Chris.
thanx you have solved my problem
bruno:eureka:
-
It's me again:D
i now have a database of 15000 songs, in column A i have the artist, in B the titles, what im wanting to do is remove duplicates, can this be done without me having to physicaly scroll down and checking?
-
just to let you know, i sorted my problem, i had to copy about 50 entries first, then the rest went in ok.
thanks again to all that helped on this subject.
goes to show what a brill forum this is
Paul (Bruno):tongue:
-
sorted now, had to do it bit by bit.
thanx guys:bsmile::tongue::tumble::D
-
chris
im copying from A1 to A4395 from 1 page then trying to paste in another page the next available number on the page im trying to paste to is A7826
-
chris,
thats just a few of my 15000 karaoke cd+g collection
-
no it says the copy and paste area are not the same size, than says click a single cell, then paste, but does not work, or select a rectangle thats the same size, not sure how to do that one.
come on denis, i thought you would have sorted this by now lol
-
ive managed to do my previous problem, now i need to paste into a existing data, but it says its not same size, ive tried clicking single cell, but no look:(
-
Denis, my missus say's thanks, so do i
-
i have a data base of 4000 songs all in column A.
ie,
animals - house of the rising sunwhat i want to do is replace the hyphens for a column.
can this be done, please help:D if it can please explain it in simple terms:eureka:
-
lol, you are a star, thankyou very much, its amazing when you spell it out like that, i can get it, thankyou to you all
-
i apologise for sounding so stupid, but im still strugling to convert all the cells in one go ie a1:a7989 which is in lower case to b1:b7989 in uppercase.
and ive just realised its office xp i have