You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

Carriage Returns when concatenating

Carriage Returns when concatenating

Price: FREE

When concatenating data in Excel 1997-2003, I used to be able to separate pieces of data using char(10).and that would effectively put in a carriage return - this made data display quite neatly, especially when text was imported into Description fields in CRM systems for example:
eg: =concatenate(A2,char(10),B2,char(10),C2) might look in real data like:
Customer=Yes
Reference Customer=No
Named Account=Yes
which is neater than using something like a semi-colon.eg.
Customer=Yes; Reference Customer=No; Named Account=Yes
Anyway, I don't seem to have any luck using my old char(10) routine in Excel 2007. Does anyone know how I can make this work again?

Visit publisher's web-site: Carriage Returns when concatenating

Category and Tags: ExcelTutorials :

Related Tutorials

Replacing carriage returns with a comma

Free: Yes
Tags: Excel ›

I have an address cell which has data with multiple lines - eg:
School of Science Medical University
and I want to do a Find all: carriage returns and replace with a comma - though I don't know the code to use for the carriage returns .

Removing Carriage Returns in Excel 2000

Free: Yes
Tags: Excel ›

I'm trying to automatically remove carriage returns from an Excel
200 Spreadsheet. I've tried the hold down alt and type 0010 or 0013 in the
find and replace, but without success.

Strip carriage returns

Free: Yes
Tags: Flash › Excel Actionscript

This tutorial will show how to strip carriage returns (or any other character) from text strings by splitting the string up and then reassembling the resulting array.

How do i hide carriage returns?

Free: Yes
Tags: Excel ›

How do I hide carriage returns? (the "boxes" behind a line of text)

Carriage returns

Free: Yes
Tags: Excel ›

I have a large number of records that I need to load into a text field on some in-house software.
The in house software has it's own inbuilt loader facility and I have no control over it. it expects a .csv file.
The problem is the data I have contains carriage returns which are making a complete mess when I try and create a .csv file.
Is there anyway to do a search and replace? and replace the carriage return with a space?
The data is currently in .xls but I could import into access if required.

Related Applications & Scripts

Check Password

Free: Yes
Tags: PHP › Excel Password Protection

Verifies that a given string is a good password. If it is a good password, the function returns an empty string. If it isn't, it returns a text string describing the flaws. The function is relatively permissive, but was written to take additional constraints.

Deals Aggregator

Free: No
Tags: PHP › Excel Web Fetching

Deals Aggregator is a thin PHP Utility class that aggregates online social shopping deals from Groupon, Living Social, Crowd Savings, and Tippr by tapping into the BuyDeals National deals database platform.
Features Include:
1. Search for Deals by city, state, zip/postal code, and latitude/longitude.
2. Aggregates deals from Groupon, Living Social, Crowd Savings, and Tippr and returns it as a common set of results.
3. Detailed Deal information including links, images, owners, price, discount, and copy description.
4. Returns aggregated deals in JSON , XML, or PHP Object formats.
5. Fast deal fetching response times.

Photoshop Styled JavaScript Color Picker

Free: Yes
Tags: JavaScript › Excel Color Picker

This is an advance color picker that handles RGB, HSL, and Hexadecimal values. It works the same way Photoshop color picker does and returns the hexadecimal value of the color.

Pepperpot: Pinging with ASP

Free: Yes
Tags: ASP › Excel News Publishing

Uses AspTear to ping Weblogs.Com, blo.gs, and BlogRolling. Returns useful messages - the return messages from each site, in fact - but don't use it if you can use XML-RPC instead.

Sake: Polynomial

Free: Yes
Tags: PHP › Excel Charts

Sake is a PHP implementation of Polynomial Least Squares Regression. The algorithm takes data points as input and returns the resulting polynomial. Graphs can be made using any plotting package. Sake provides the polynomial and will compute as many points as desired.

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing