Excel 2004 Mac Version - INSERT LINE BREAK IN INFORMULA

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have hundress of lines were I want to combine 3 columns of data (Address,
City, State) in a single cell, but I want to INSERT a line break so the text
is on three lines in the same cell. I have seen a post regarding the
Char(10) command, but this does not work for me. Is this a Mac Office
problem? or is the Mac Solution different? If anyone can help, I would be
very grateful. Thanks
.

Relevant Pages

  • Re: Excel 2004 Mac Version - INSERT LINE BREAK IN INFORMULA
    ... > I have hundress of lines were I want to combine 3 columns of data (Address, ... > City, State) in a single cell, but I want to INSERT a line break so the text ... Is this a Mac Office ...
    (microsoft.public.excel.worksheet.functions)
  • auto value throug look up wizard
    ... testing the results wher i am stuck with this problem ... In Access, if i put a value in a single cell, the other cell ... city coloumn if i enter the city from lookup vizard then it should ...
    (microsoft.public.dotnet.general)
  • CSV File
    ... I have a CSV file that contains an address in a single cell with the ... various components (name, address, city, state, zip) all separated by ... I need to search the cell find the coma press alt enter then ...
    (microsoft.public.excel.misc)
  • split cell content
    ... I have a lot of imported data, unfortunately the post code and city is ... 12159 Berlin ...
    (microsoft.public.excel.programming)