Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all
i'm trying to split a text, actually a real easy task, excel provides the split function! But what if I want Excel to use each character as a substring?? i.e. "Hello" == "H","e","l","l","o" Is this possible? I want to make a function which returns me a string, with a space between every character: "Hello" == "H e l l o" If I could split up the string, i could join it again, and put a space between each character. Possibly there's another / better solution for my problem, if so, i would be real glad if you could tell me :) Thanks a lot for everything Cheers Carlo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text Split | New Users to Excel | |||
Split a text | Excel Worksheet Functions | |||
Split text without using data-text to columns | Excel Discussion (Misc queries) | |||
Split Text | Excel Discussion (Misc queries) | |||
text cells end page how split to next. Text lost! | Excel Discussion (Misc queries) |