bingobango
New member
- Joined
- Apr 11, 2022
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Microsoft 365
Hello,
I am attempting to automate the replacement of certain characters in a text string with a single formula. The format of the cell may be either number or text, if it matters.
Specifically, if the first two characters in the string are any of "09", "10", "15", "16" then I want these to be replaced with "NE".
If the first two characters are, "11", "12", "13", "14" then I want these to become NW.
01, 02, 07, 08 to become SE and 03, 04, 05, 06 to become SW.
I often use Defined Names for given column for this, but in this instance I am getting a #SPILL! error when trying to do so.
Any wizardry that can be imparted is most appreciated!
Sample workbook attached with desired outcome manually entered.
I am attempting to automate the replacement of certain characters in a text string with a single formula. The format of the cell may be either number or text, if it matters.
Specifically, if the first two characters in the string are any of "09", "10", "15", "16" then I want these to be replaced with "NE".
If the first two characters are, "11", "12", "13", "14" then I want these to become NW.
01, 02, 07, 08 to become SE and 03, 04, 05, 06 to become SW.
I often use Defined Names for given column for this, but in this instance I am getting a #SPILL! error when trying to do so.
Any wizardry that can be imparted is most appreciated!
Sample workbook attached with desired outcome manually entered.