LinkBack URL
About LinkBacks
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks