![]() |
|
|
|
#1
|
|||
|
|||
|
FYI for future reference,if you do not wish to affect other data in your workbook, copy & paste the text strings into a new blank workbook. Select the entire column containing this text string, choose Data > Text to Columns. Choose the File type as Delimiter then click Next, Change the type of delimiter to "space" (easiest option), then you can either just click Finish and your text string should be shown separated into column I, you can then cut & paste column I into another workbook for use. This is 2 minute process at most to complete.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Way to search for a string in text file, pull out everything until another string?
|
omahadivision | Excel Programming | 12 | 11-23-2013 12:10 PM |
Extracting a phone number from a string that contains text and numbers.
|
hommi16 | Excel | 2 | 06-05-2013 09:19 PM |
Find and replace a string of text
|
errtu | Word | 1 | 01-31-2013 02:09 PM |
Convert numbers to a specific text string
|
francis | Excel | 1 | 10-06-2011 01:43 PM |
| Extract numbers from a text string | aleale97 | Excel | 4 | 02-10-2011 10:33 AM |