Calling Excel Freaks

this is probably simple BUT not for me

[Eric in Tennessee]

Hello all who gander my scribble:

I feeling a little bizarre this evening! Anyway, if you copy something from say, hmmm, well, Overture Suggestion tool and copy it into a spreadsheet, it places a nasty space before everything in each cell. I am not sure if I am using the correct terminology, so allow me to produce an example:

Overture Suggestion for September 2003
1250 widget exterior
1240 widget interior

now when you copy and paste that into an Excel Spreadsheet, you get this:

Columun A Column B
<space>1250 <space>Widget exterior
<space>1240 <space>Widget interior

My QUESTION is:

is there a simply formula for getting rid of that space without having to type each one in again (which is what I am doing now--Don't yell at me, I don't know what to do!)

Thanks all!

eTN

ISSUE RESOLVED! Thanks everyone :)

[edited by: Eric_in_Tennessee at 5:06 am (utc) on Oct. 22, 2003]

[Mark_A]

look in I think tools and "text to columns"

[deejay]

*whispering* pssst.. over here.

Paste the list into Excel normally.

Then place your cursor in one of the number cells.. select that little space to the left of the number with your cursor and hit Ctrl+C to copy it.

From the menu select 'Edit' 'Find' 'Replace'.

In the 'find' box, hit Ctrl+V to paste your little blank space that you copied (it's not a normal space, so space bar doesn't work - hence copying it).

In the Replace box put nothing.

Select the option to replace by columns (as opposed to rows). Your cursor should still be in the number column.

Hit 'replace all' and watch them lil suckers fly over to the right like real numbers.

[mansterfred]

Eric

Sounds like a hidden character or two. Usually a return character is the culprit.

You can write code, but in spreadsheet format one of these ideas should complete the task in less the a minute.

2 suggestions:

1) Parse the data, nuke the space, then reform the data.Parse Found In Data List, now simply known as Text to colums.
2) Select a cell, determine how many extra spaces have been placed, goto replace once determined and replace extra spaces with none(ie do not put anything in the replacement box. Replace found in edit list.

mansterfred

[Mark_A]

Ok I am not shouting but I resent being suggested as a freak! :-)

[Eric in Tennessee]

I am smiling MARK!

Thank you all for the suggestions.

Deejay - It worked like someone gett'en overtime. Thank you.

eTN