Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace a character by it's place in a string
Hoping there's an easy way to do this.
Tried the hard way (Left, Right) and it works but I was looking for an easier way. I need to replace a character in a string by it's position in the string. i.e. String = "aaaaaaaa" Replace the 5th character with "Chr(10)" Result = "aaaa(Chr(10))aaa" Thanks for your help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace font of one character in a string | Excel Programming | |||
How replace a character in a string of characters? | Excel Programming | |||
Replace character in string, not document | Excel Programming | |||
Function to return Character Position of Xth character within a string | Excel Programming | |||
How do I replace * as a character in a string in Excel? | Excel Programming |