Excel help needed

[Shaun]

Hi,

I am trying to export data i have on my excel work sheet to a text document, i know how to export it but what i need is to remove the spaces between the cells so i can upload the bets sheet directly to the TAB with a format they under stand.

On the sheet below you will see 2 examples the top one is the way it exports the bottom one is the way i need it.

I would say a macro is need to do the job but i am hopeless at them.


Also does having a space between the bets effect if they will be taken or not.

[stugots]

'substitute' may help if the data is all in one cell

=SUBSTITUTE(A1," ","")

if the data is spread over several cells then combing them into one & then using 'substitute' should work

[Shaun]

I never thought of joining them, will try this i shouldn't need substitue when they are joined.


PS worked great, just have to test if the Tab system will accept it will gaps for scratchings

[Shaun]

Ran in to a small problem, when joining them like this.

=F39&G39&H39&I39&J39&K39&L39

It changed my number format from,
00006.0

to

6

How can i keep the number format?

[stugots]

i didnt get that same prob shaun -

WR-03-QQ- 00006.0 / 3 , 4 /

=F39&G39&H39&I39&J39&K39&L39

produced

WR-03-QQ-00006.0/3,4/

the cells F39 to L39 i have formatted as TEXT & the formula cell as GENERAL,

[Shaun]

I solved the problem another way but will check that out, thanks for the help.