Split data from name field

		Microsoft Office Forums > Microsoft Excel > Excel
Split data from name field

FAQ

Thread Tools

Display Modes

02-06-2016, 01:05 AM

Pecoflyer

Windows 7 64bit Split data from name field

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Quote:

Originally Posted by BudVitoff

. This is why in all cases where leading or trailing spaces could present a problem, the data should be "trimmed"; i.e., those spaces should be removed from the data before applying any logic.

Which can be done using the TRIM function ( whether or not spaces need to be removed)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to split merged data into vertical saperate cells	cheekugreat	Excel	5	10-11-2014 05:53 AM
How to format WORD data using edit field?	Azuki	Mail Merge	2	04-01-2013 06:08 PM
Merge field source data field	kckay	Mail Merge	4	03-25-2013 11:06 AM
Mail Merge - If a field is black, take the data from the row below?	mikeprent	Mail Merge	5	01-05-2012 04:52 AM
Split Data from One Cell Into Two	Karen615	Excel	3	09-20-2011 06:36 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:12 AM.