Hello,
I have paragraphs of text in which some texts are partially been cut and moved to next line. Is there any suggestions how to merge it with word macro?
For example, If we press backspace it will merge with previous line in word right likewise
FYI, first 5 lines of the word doc should not be altered with this.
I guess this is not the correct place of the forum to ask a MS Word question..
BTW, you dont need a macro for this, you can just use simple Find-Replace method for this....
- Select the part of the document that you want to make the changes,
- Activate "Replace" menu,
-Enter ^p in the "Find what" box, leave empty the "Replace with" box,
- Hit "Replace All" button.
.
Hi Haluk,
Its a macro between Excel and word. I need code to automate completely.
I tried your suggestion problem is it deleted space between paragraph as well and also first five lines?
It has to delete line breaks between paragraph with first five lines untouched
Hi priyad,
I,m answeri g from my phone so I i cannot write the code for yuo.
The character you mention is called a linefeed..
In vba you can use vbLF or Chr(13).
A lineferd is character 13
Depending on your needs you can use eighter option to find or replace the character as needed..
Last edited by Roel Jongman; 07-01-2019 at 01:59 PM.
Hi Roel,
Yes, I researched some on line feed and couldn't find better solution yet.
To be more clear, i'm trying to find text from word and move it to excel using macros. It's almost completed but stuck with these line breaks on very few and causing an error
Example my text is like below in Word
173 73079290 ADAPTER AS.-ELBOW 90 DEG (NON ELECTRICAL) (50 NOS)
| 1068715
158 84829900 CUP-TAPPERED(69320-BEARING CUP) (1152 NOS) | 12389
08
155 84829900 CUP-TAPPERED(69320-BEARING CUP) (866 NOS) | 123890
8
I want to be like below for excel run further without any error
173 73079290 ADAPTER AS.-ELBOW 90 DEG (NON ELECTRICAL) (50 NOS) | 1068715
158 84829900 CUP-TAPPERED(69320-BEARING CUP) (1152 NOS) | 1238908
155 84829900 CUP-TAPPERED(69320-BEARING CUP) (866 NOS) | 1238908
I made sure to delete all white spacing. All I need to take care of line breaks and Need to make sure first five lines of word doc not been affected by any means
Last edited by priyadharshane; 07-01-2019 at 02:41 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks