Column A deleting a space

[charlie11k]

In my column A I have a space before all my text in every row......how can I delete that? I have a lot of records so doing it for each will take forever.

[jj72uk]

New column:

=RIGHT(A1,5)

Copied down

Then delete col A if needed

[charlie11k]

Maybe I need to supply you with more info:

A1
Roy & Ann Miller

what i need is:

A1
Roy & Ann Miller

notice my second A1 has the text moved over to the left on space......it is that stupid space I am trying to delete in every row for Column A......what you gave me did not work at all.

[shg]

Perhaps =trim(a1)

[martindwilson]

if its in every row
select column
use data/text to columns/fixed width
clear any break lines
insert one breakline in front of text
click next then chose the dont import column(skip) option
click finish

[charlie11k]

Ok, the trim formula looked like it worked on the actual excel spreadsheet but when I do mail merge into Word.....it does not align my name justified with the address........help! I tried the text to column option and that did nothing.

[martindwilson]

post a sample of your work book just a few rows will do
if its sensitive given that its names
delete all the characters except the first 2 or 3(leaving the space in before them)
as for text to columns did it look like this(actual layout may vary in different excel versions)

[charlie11k]

I am not sure if I can just paste this but on top of not being able to figure this out now for hours, I do not have time to figure out how I can attach my document. This is getting very frustrating! My freakin Word mail merge is putting a space before my address block and I don't know why.......here is an example of my first record I pasted

ROY E & IVA B MILLER
02096 VISTA CT how can I move that Roy name over to the left!?

ROY E & IVA B MILLER 02096 VISTA CT
DONALD K JR & CARLA J MOFFITT 03021 BARKRIDGE CT
EDWARD L PRICE 03033 ASH CT
ANTHONY E & ARMINDA L GRISSETT 03034 ASH CT
WAYNE OWENS 03036 ASH CT
RICK & RHONDA HOLDEN 04014 WHITECREST DR

[teylyn]

Charlie, I strongly advise you to read the forum rules, especially about cross posting.

http://www.excelforum.com/word-forma...ail-merge.html

I do not have time to figure out how I can attach my document.

This is a bit surprising, since you obviously expect people here to invest time to work on your solution. You may want to invest a minute or so to find out how to attache a file.

regards

[charlie11k]

Cross posting? maybe you should see it from my point here.......How do I know that an excel guy will know if it is a Word issue? That is the only reason I asked it in 2 different forums....maybe you guys should consider this?

[charlie11k]

If I can get the answer about a possible Word issue here......then delete my other post......how can I know that?

[teylyn]

Easy, man. There are reasons behind the cross posting rule, even if you don't understand them. All we're asking is that you link to cross posts, so we can see what others have already considered.

[charlie11k]

Oops.....didn't know that was what you were saying....I thought you were implying I couldn't do it........you're just saying to paste the url between both?.......Well what do I need to do here......I am getting drained trying to figure this out.....I'm about to just print my envelopes as is with the name not aligned because I am tired of trying to figure it out.

[teylyn]

Well what do I need to do here.

Start with reading the forum rules.

Again, as MDW and I have asked before: post a sample of your Excel data and your Word merge file. It is impossible to suggest a solution if we can't see what you have in place.

Copying your data into a post does not help. We need to see the structure of the data in the excel sheet and the way you've set up your merge fields in Word.

[martindwilson]

1 have you proved its not word by putting some names in the column without leading space then trying the merge?
2. did you try changing the merge field to look at the column with trim(a1) in?