Originally Posted by Ace_XL Maybe.. =REPLACE(A1,6,2," "&RIGHT(A1,2)) My data is in column c, does that make a difference ?
=REPLACE(A1,6,2," "&RIGHT(A1,2))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks