Didn't think this was going to be such a challange

[jrb]

I am working on a spreadsheet that places a letter at a price and time
Were time1 is the letter A, time2 letter B, ect ie.

Price time1 time2 time3

1............. A............................C
2............. A............B..............C

3 ...........................B..............C

(note: the dots are just used as place holders for this post)

What I need to do now is move each letter so to fill the gaps ie:


1 A C

2 A B C

3 B C


I am at a lose as to where to go from here any ideas that I can try t
explore. I hope I explained the problem clearly.

Thank you for any and all ideas

J

 

[A.W.J. Ales]

Jr,

Select the range containing your filled and empty cells.
Edit / Go to / Special and select "blanks"
(This select all your empty cells )
Edit / Delete and select shift cells left.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[vishal]

Try this one.

say cell A1 contains 1 Cell B1 contains A and Cell C1 contans C

in a blank cell .. (say D1) write the following formula:
= A1&B1&C1
In that case, the cell D1 should return 1AB
In case you want to insert a single space in between 1,A and B, tr
using
= A1&" "&" " &B1&" "&C1
In this case the cell D1 shall return
1 A B

I hope this works, if I got your problem right