| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I convert the format? (Please see msg for details)
I have once sheet with more than 500 blocks of data in this format:
--------------------------------------|-----------------|-------------- comapny1 --------------------------------------|-----------------|-------------- Website: web1 --------------------------------------|-----------------|-------------- Location: loca1 --------------------------------------|-----------------|-------------- How can I convert them to a arranged format like this: --------------------------------------|-----------------|-------------- COMPANY | WEBSITE | LOCATION --------------------------------------|-----------------|-------------- company 1 |web1 | loca1 --------------------------------------|-----------------|-------------- company 2 |web2 | loca2 --------------------------------------|-----------------|-------------- company 3 |web3 | loca3 --------------------------------------|-----------------|-------------- Upendra Singhai ______________ visit: www.upendrasinghai.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
| Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
| Create a custom format to convert seconds to minutes. | Excel Discussion (Misc queries) | |||
| convert a numerical currency into word format | Excel Worksheet Functions | |||
| convert .123 format to Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
