Hello, is there a way to split text by character, like text to colum, for example by " # "
If i have: My # Name # is # Stephan
to split each word in different cell.
Hello, is there a way to split text by character, like text to colum, for example by " # "
If i have: My # Name # is # Stephan
to split each word in different cell.
Did you try "Text to Column" using " # " as the delimiter ?
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
Yes, but i need to do this with formula. Exactly like text to column but with formula
Try this...
A1 = My # Name # is # Stephan
Enter this formula in B1:
=TRIM(MID(SUBSTITUTE(" # "&$A1," # ",REPT(" ",255)),
COLUMNS($B1:B1)*255,255))
Copy across until you get blanks.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
=TRIM(MID(SUBSTITUTE($A1,"#",REPT(" ",LEN($A1))),(COLUMNS($B1:B1)-1)*LEN($A1)+1,LEN($A1)))
IF YOU HAVE YOU DATA IN CELL A1 TRY ABOVE FORMULA
Edit the range as per your need
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Thank you very much! It works great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks