A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries)
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Line Breaks in cells - Mac OS X Leopard



 
 
Thread Tools Display Modes
  #1  
Old August 7th 08, 07:14 PM posted to microsoft.public.excel.misc
plunkettphoto
external usenet poster
 
Posts: 1
Default Line Breaks in cells - Mac OS X Leopard

Using Excel 2004 for Mac v11.5

I have a spreadsheet delivered to me from a 3rd party which contains an
address list. The address cell has the city state and zip all together in
one cell apparently separated by a line break character because the wrap text
causes the cell to divide into multiple lines with the city state and zip on
separate lines - there are most likely 2 line breaks because there is a blank
line between each data line.

Is there any way to automatically separate the three fields into 3 columns?

thanks,
bill plunkett
Ads
  #2  
Old August 7th 08, 08:34 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 35,220
Default Line Breaks in cells - Mac OS X Leopard

I don't use a Mac, but if the cell really contains those alt-enters (line
breaks), I could do this on a wintel machine:

Insert a couple of extra columns to the right of the column with the addresses.
Select the column with the addresses
data|text to columns (xl2003 menus--I don't know on xl2004)
delimited by other
I'd use ctrl-j
(or hold down the alt and hit 0010 on the number keypad)
skip (do not import) the empty fields)
and finish up.

Save your workbook first--so you can close without saving if it screws up your
data (or just use undo???).

You may want to post he
news://msnews.microsoft.com/microsof...c.office.excel
if this suggestion doesn't work.


plunkettphoto wrote:
>
> Using Excel 2004 for Mac v11.5
>
> I have a spreadsheet delivered to me from a 3rd party which contains an
> address list. The address cell has the city state and zip all together in
> one cell apparently separated by a line break character because the wrap text
> causes the cell to divide into multiple lines with the city state and zip on
> separate lines - there are most likely 2 line breaks because there is a blank
> line between each data line.
>
> Is there any way to automatically separate the three fields into 3 columns?
>
> thanks,
> bill plunkett


--

Dave Peterson
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Line breaks in my cells... AkelA Excel Discussion (Misc queries) 3 October 3rd 07 07:18 PM
Line breaks pdgood Excel Discussion (Misc queries) 3 December 5th 06 02:42 AM
Line breaks in Excel? sawyet5 Excel Discussion (Misc queries) 3 November 9th 05 07:16 PM
Inserting line breaks into merged text cells. MrSafetyNeedshelp Excel Discussion (Misc queries) 1 August 11th 05 10:12 PM
Line breaks KatoKat Excel Worksheet Functions 1 March 1st 05 10:04 PM


All times are GMT +1. The time now is 07:04 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.