Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

How to remove spaces in mail merge

Here's the deal, we merge excel columns into address labels. Everything works great. Problem is when we have an address where there's no first or last name, just a company name. WE set up the labels like this:

<<First>> <<Last>>
<<Company>>
<<Address>> etc

When there's no first or last name, the space that we manually insert in word remains there, so that when the company name gets moved up to the top line it ends up looking like this:

Company X
123 Main Street
Anytown, CA

The company name is indented by that one space. Is there any way to get Word (or Excel) to ignore that space if there's no first name and last name?


Post your answer or comment

comments powered by Disqus
hi
I want to remove spaces in a middle of a cell/column.

regards

P.M.SANJAY

How to make Text in a Merged Cell of different Font(s) & Font Size Programmatically?

Dear Forum,

I have a particular Form which is basically a Blank Template and which is going to be used with Dynamic Names and then further for Printing.

The names are going to be selected from a Drop-Down and that is concatenated in the Template TEXT..

TO make it look more Authentic I want to haev this Text in a Different Font and Larger Font Size than the remaining text..

Ex:-

Cell B6 =

Received with thanks from MR. SACHIN RAMESH TENDULKAR a return of income and/or return of fringe benefits in Form No. ITR … for assessment year 2009-10, having the following particulars.

AS you can see the reamaining text is of normal Times New Roman Font and regular Font Size.

This TExt is Pulled from a DropDown connected to a List Names in the cell U1.

U1= MR. SACHIN RAMESH TENDULKAR

="Received with thanks from"& MR. SACHIN RAMESH TENDULKAR &"a return of income and/or return of fringe benefits in Form No. ITR … for assessment year 2009-10, having the following particulars."

So ,how DO i manage this difference in Font(s) and FOnt Size in a single cell which is Merged.

Warm Regards
e4excel

Dear All,

I am trying to use mail merge through word document using a list of emails stored in separate excel file. However, I noticed it that I can not add the "CC" in the e-mail. Can any one help me?
Thanks in advance!!!!!

Dear all,

In cell, I have the text with many Space at many different position.
How to remove them with conditional at [A1]?

Example : ab c ed mjg kjk

If (a1=4, remove the first space, if (a1=5, then remove the 2nd space, ,,, repeat formula to remove all the space)

Thank you,
vumian

I have one excel sheet. In sheet no of customer name approx 6000 customerlist.

I want to remove space after finishing of complete name. Attach file for your ready reference. If you press F2 on customer name to see after completed name one space show. Let me know the how to remove in one attempt to remove those space gap. Any forwmula or any trick. Cofirm per return.

Hello, This is a simple question as to why Excel does what it does dealing with the Replace feature. I have already found a solution on how to remove the spaces between numbers in a cell. The =Substitute(A1," ","") formula worked fine.

What I want to know is why when I removed them using the Replace option, the numbers are all changed. No matter what format I choose the number would change after replacing all the spaces with nothing. This was very frustrating and I am inquiring about this as a way to ease my frustration on this topic. I will include an example of the numbers I am dealing with as well as the working formula. Please try to use the Replace feature and see if your results are any different then these made up numbers it have been giving me.

Please feed me your knowledge.

Thank You!

cell A1 has " HH001 " (without "", there is space infront and behind the data),

cell B1 has "motor gear case",

what formula to put in cell C1 to get like this "HH001" (removed spaces in A1)

and D1 to get like this, "[HH001] motor gear case"

Thanks for any help,

I try to remove an add-in, ProjeX, which , after a year of silent
non-use, installed itself seven times in the uppermost task bar. I looke
in Help for how to remove add-ons but this did not help. I opened the
add-in menu and clicked on Remove Add-in, no effect. I tried Tools >
Customize and clicked avery possibility (incl. reset) , no effect.

Any help appreciated.

Frank

Hi All, Newbie needing Help here.

I have received a file from an SQL script that was saved into Excel format. I noticed there are spaces in all the colums at the beginning of each result. I tried to use the TRIM function but as usual the Noob in me has no idea what it is. If anyone could Guide me in step by step (in a simple English preferrably ) it would be much appreciated.

PS: I was trying to add a screen shot to explain my problem but I guess this Forum wont allow it.

PPS: Saved it as attachment..

Is there an eay way to remove spaces in a range of cells ?

Thank you in advance.

I currently have a set of names and addresses that I want to send christmas cards too

At present I have every member of the household listed but I was wondering if it was posibble to group each household instead of sending the card to everyone.

My table looks like this:

Callan, Cxxxy, Wayside, Ardrxxxgh, Athy, Co.Kilare, The Callan Family
Callan, Lxxm, Wayside, Ardxxxgh, Athy, Co.Kilare, The Callan Family
Callan , Mxxxt, Wayside, Ardxxxgh, Athy, Co.Kilare,The Callan Family

I'd probably need to group by "The Callan Family" colum where The address column "Wayside" is equal

Just not sure how to do that in mail merge

Any help would be great

I want to do it automatically for a group of cells.

for example, if the word in a cell is "a b c", after spaces are
removed, the new word in the cell will be "abc"

how to do it by using VBA? thanks!

How Do I Add Commas To Columns And Remove Spaces In Excel??

I need to create lists with the use of 3 columns, i.e., first name, last
name, date
so that it ends up like below when I select all three columns and then copy
and
paste to a text editor like Word Pad ...

first-name,last-name,date
first-name,last-name,date
first-name,last-name,date
first-name,last-name,date

Thank You!

Zack
www.zeel.biz

Hi,

How to remove Starting Empty space in a cell

Input

Pack my box with five dozen liquor Jugs

Required Output

Pack my box with five dozen liquor Jugs

How to remove the <first empty space> before the wore <Pack> Please Help with a formula. Thanks in advance

How to remove the " " blank spaces which are added with formula in a Range with MACRO

Dear Forum,

Some formulas in order to show blank cells add " " blank spaces but now I want to remove such blank spaces with Macro..

I cannot change the code of adding it in the first place as that would mean changing the entire design however I want to just get rid of some of the blank spaces in the cells as when I am doing a CountA on this column I do get them in the count.

I have tried using the

Range("A2:A200").Value = ""
Range("A2:A200").clearcontents
But in vain for some strange reasons the blank spaces just dont go...

Warm Regards
e4excel

Does anyone know how to remove (via formula or VBA code) unknown Character returns?
I've tried =trim =clean =substitute, but nothing works. I'm just trying to remove the spaces, but I don't know what type of character return (or other code) is in the cell that I'm trying to clean.

Please help.

Tim

Hi,

Can any one clarify how to remove merged cells, autofit the data and center
align the contents by having a formula.

Thanks in advance

We have a merge file set up in Word 2000 that merges with an Excel file which
imports its data from a text file and gets "refreshed" with each use.

These files are used by a number of individuals, but one of the users
recently upgraded to Office 2003 and is now getting a prompt whenever he uses
the merge file(s) stating there is an "SLQ query attached to this
file....should it be activated.." and "Do you want to refresh data?"

My coworker does NOT want to have to answer these (and other) prompts when
entering a file, but I can't figure out how to remove them.

Can someone tell me where this option is located so it can be "turned off"?

Thanks!

We have a merge file set up in Word 2000 that merges with an Excel file which
imports its data from a text file and gets "refreshed" with each use.

These files are used by a number of individuals, but one of the users
recently upgraded to Office 2003 and is now getting a prompt whenever he uses
the merge file(s) stating there is an "SLQ query attached to this
file....should it be activated.." and "Do you want to refresh data?"

My coworker does NOT want to have to answer these (and other) prompts when
entering a file, but I can't figure out how to remove them.

Can someone tell me where this option is located so it can be "turned off"?

Thanks!

I have a spreadsheet that uses currency. When I mail-merge into Word
document, the currency doesn't convert correctly. For example the $ sign
does not come across, the diget 0 does not convert if its the last digit
(i.e. in excel $20.50 - converts to Word in mail merge as 20.5) and if the
currency does not end in 0, it converts with 4 digits after decimal point
(i.e. $20.51 converts to 20.5142).

I have a spreadsheet where the date is for example 11/19/2007 and I click Format and I change that so it reads: November 19, 2007....which is the end result I want.

However....when I look in the fx bar it still shows 11/19/2007 and when I open word and do a mail merge using that ewxcel spreadsheet as the source....it converts back to 11/19/2007.

How can I complete a mail merge using Excel as the data source where the date will be spelled out instead of numeric?

Thanks!
Shane

Range A1 : A10 (*every cell contains formula)

A1 | Mumbai
A2 | Chennai
A3 |
A4 | Delhi
A5 | Kolkata
A6 |
A7 | Bangalore
A8 |
A9 | Hyderabad
A10 | Kerala

data validation -----> Allow ------> List------> Source---->"A1:A10"

after applying the datavalidation ,I can see the drop down list with data as well as blank cells (i.e, A3, A6, A8)

how to remove that blank cells in drop down list

Reagrds
Arool

Anyone knows how to remove Alt+Enter characters in a worksheet?

Thank you.

I'm trying to do a Mail merge in word to have Photos match with a name,
however I cant seem to get the photo to happen. i can get the hyperlink to
work, but nothing else. any advise, l8ike maybe being able to have a picture
in the cell


No luck finding an answer? You could always try Google.