silentwolf
Well-known Member
- Joined
- May 14, 2008
- Messages
- 1,216
- Office Version
- 2016
Hi,
I asked that same question on my previous post but thought it would be better to start a new post for this.
I got in one column "Names" they can start with an asterix "*p* Sometext"
this can very from "*p* sometext
to *E* Sometext
or other text with *different length* somthing like "*TOP S+E* sometext"
So I like to find the second "*" from left and add a space if there is no space.
"*TOP S+E*textwithoutSpace after the asterisk
of course I need to keep the remaining Text.
So I guess I should use instr Function to find the second "*" but then how to I find if there is a space or no space after the asterisk and how to add one if there is non ??
Hope that is clear what I mean?
Cheers ..)
I asked that same question on my previous post but thought it would be better to start a new post for this.
I got in one column "Names" they can start with an asterix "*p* Sometext"
this can very from "*p* sometext
to *E* Sometext
or other text with *different length* somthing like "*TOP S+E* sometext"
So I like to find the second "*" from left and add a space if there is no space.
"*TOP S+E*textwithoutSpace after the asterisk
of course I need to keep the remaining Text.
So I guess I should use instr Function to find the second "*" but then how to I find if there is a space or no space after the asterisk and how to add one if there is non ??
Hope that is clear what I mean?
Cheers ..)