I am looking for a right, left, mid function that goes up a a certain variable. For instance, I have a cell that needs to be broken out into two cells, The seperation indicator is "#". I have been playing around with it and can not get this to work. I know that it is simple but my brain is not functioning today.
Example:
Column A Column B
111#2222 I need 111 2222
3#1 I need 3 1
Sorry I am wasteing a post on this.
Example:
Column A Column B
111#2222 I need 111 2222
3#1 I need 3 1
Sorry I am wasteing a post on this.