Converet plain text to table
Just to clarify Suzanne's advice...
After the replace, you will see the list looking like:
[1.] tab [name] tab [surname] tab [0:36:27] return
Then when you select the list and use convert Text to Table choosing the TAB
as the separator, you will have a four column table. If you need the empty
space afterwards, you simply select the column to the right and chose
Insert, Column to the Left (or vice versa).
BTW, if you are ever going to place the table in a spreadsheet, you should
consider changing your order numbering system because it may be confused as
the standard time format (hours:minutes:seconds): it certainly confused me
at first glance.
Terry
"geotso" wrote in message
...
I have a "table" in plain text like this:
1. [name] [surname] 0:36:27
2. [another name] [and surname] 0:46:27
3. [third name] [and surname] 1:03:42
4. [and so one...] 2:04:18
Whe
- After the order number there is an empty space
- Between [name] [surname] there is an empty space
- Between [surname] [time] there are empty spaces and/or tab characters.
Is there a simple way to convert it to a table (I don't know VBA)?
--
Please remove hyphens to contact me
----- --- -- -- -
geotso
----- --- -- -- -
|