Replies to post #115 on Learning Microsoft Excel

[lobogotti]

very good.

that is Advanced Excel work. you should see some of the formulas i have typed up, one is 500+ characters long.

[lobogotti]

since you seem to pick this up rather well, let's move back to the first step. only this time i want to take those seven digit numbers and put a * in between every number.

for an example, they should look like this.........

6*4*9*7*3*2*1

now remember, i have 10,000 parts that i want to do this with and i need a quick way to achieve my deadline.

can you think of a way to accomplish this?

hint, you wouldn't use a LEFT or RIGHT command, but instead a two part function. CONCATENATE would be the second function. what would be the first? how can you break up all of those numbers?