Hi all,
Suppose cell has 15 characters 0 and 1,I want the letters corresponding to the position of number 1 placed together.
For details, see the sample files.
Thank you.
Hi all,
Suppose cell has 15 characters 0 and 1,I want the letters corresponding to the position of number 1 placed together.
For details, see the sample files.
Thank you.
Use VBA:
![]()
Public Function Conve(StrText As String) As String Dim i As Long For i = 1 To Len(StrText) If Mid(StrText, i, 1) = "1" Then Conve = Conve & ChrW(96 + i) Next End Function
I have provided two ways to do this, one with a formula and one with a user-defined function (macro). The formula is long, one IF for each character position. The macro is cleaner to use if you don't mind macros.
Answers worked properly...
Thank you both very much for your time with this, much appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks