Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Separate address column to Five columns
I’ve been given a spreadsheet to work on, look to be an export from a database. It has addresses of companies; 3 columns in total: Company Name, Company Address and Company Telephone. Unfortunately I need to separate the Company Address Field to Five columns: Address 1, Address 2, Address 3, Address 4 and Address 5. Is there a quick way of doing this or a magic formula??? Thanks -- harpscardiff ------------------------------------------------------------------------ harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960 View this thread: http://www.excelforum.com/showthread...hreadid=468253 |
#2
|
|||
|
|||
Are the five parts of the Company Address all in one cell?
-- Gary''s Student "harpscardiff" wrote: Ive been given a spreadsheet to work on, look to be an export from a database. It has addresses of companies; 3 columns in total: Company Name, Company Address and Company Telephone. Unfortunately I need to separate the Company Address Field to Five columns: Address 1, Address 2, Address 3, Address 4 and Address 5. Is there a quick way of doing this or a magic formula??? Thanks -- harpscardiff ------------------------------------------------------------------------ harpscardiff's Profile: http://www.excelforum.com/member.php...o&userid=25960 View this thread: http://www.excelforum.com/showthread...hreadid=468253 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Value between 2 dates | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
I have ad address in one column. I need to break apart the data | New Users to Excel | |||
split a single column into 2 separate columns | Excel Worksheet Functions | |||
How can I see column headings of hidden columns in Excel before u. | Excel Discussion (Misc queries) |