Reading individual characters of of a string - French version of Excel

[mtheriault]

Hello to all

Fist thing fisrt, I want to wish you an happy and joyfull year

Now the question.

I use a string as a minidatabase for a series of cells. This string is built by reading each cell in the range. Each content is separated qith a coma. At the end my string may look like "b,s,,b,,,b,b,s" In this case, a coma is like a tab.

Now i want to do the reverse. How can i readback each charater in the string variable so i can replace it to the appropriate cell.

Note: Since i use "fusioned cell, cells tight together" i cant use the excel convert tool.

If my question is not clear, dont hesitate for new explanation. English is not my fist language.

Martin T.
Montreal, Canada

Marttin

 

[Norie]

Martin

It's still not clear what you are trying to do here, and using merged cells, especially when working with code is not a good idea.

Merged cells are just evil.

Not sure if this is a good translation - I just used the Yahoo translation facility.

It' ; s toujours non clair ce que vous essayez de faire ici, et employant les cellules fusionnées, particulièrement quand le travail avec le code n'est pas une bonne idée. Les cellules fusionnées sont simplement mauvaises.

 

[Bruno_x]

Martin,
If your text like "b,s,,b,,,b,b,s" always have the same pattern, you could use the function MID (english) or STXT (french)

 

[mtheriault]

Martin,
If your text like "b,s,,b,,,b,b,s" always have the same pattern, you could use the function MID (english) or STXT (french)

Thank you Bruno, i will have a look at that

Martin