Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am copying a number of columns from a PDF file and pasting in Excel. It
pastes with spaces between words and between columns. The columns look like this: # TEXT (between 2 and 6 words) # # # # # (where each # means there is a number in that column.) i.e. 103 Deer Park CDP 23 476 9,435 334 234 103 Harbor on the Hill Village 34 543 12,345 332 555 Converting text to columns is a problem since there are differences in the number of words. What I would like to know is: Is there a way to first extract all the text from each line and put it into another column and then I can do convert text to columns on the rest of it. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extracting Text | Excel Worksheet Functions | |||
Extracting Text only | Excel Worksheet Functions | |||
Extracting Text from the right | Excel Worksheet Functions | |||
extracting text only | Excel Worksheet Functions | |||
EXTRACTING TEXT | Excel Discussion (Misc queries) |