PDA

View Full Version : Joining text in selected cells



andytpl
08-21-2007, 10:35 PM
After copying and pasting from a pdf file, the copied text are split up into different rows. which I have to edit so that the text belonging to the same sentence are into one cell. I would be please if someone can show me how to create a macro that will allow me to join the text into a single cell.

Bob Phillips
08-22-2007, 12:19 AM
This simple maxcro takes the activecell and pulls the data from the cell below. It can be done to repeat on selected cells



Public Sub Test()
With ActiveCell
.Value = .Value & " " & .Offset(1, 0).Value
.Offset(1, 0).Delete shift:=xlUp
End With
End Sub

RichardSchollar
08-22-2007, 01:17 AM
After copying and pasting from a pdf file, the copied text are split up into different rows. which I have to edit so that the text belonging to the same sentence are into one cell. I would be please if someone can show me how to create a macro that will allow me to join the text into a single cell.

Also, depending on how much you are copying at one time, if you Edit (ie F2) the destination cell before pasting, then paste, it should all be pasted into the single cell.

Richard