| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separate characters in a string
viadisky Wrote: Hi, I would like to convert this string --- FastEthernet0/1/0 to FastEthernet 0 1 0 Can anybody suggest a formula to do this? Any help will be appreciated :) =LEFT(A1,12)&\" \"&MID(A1,13,1)&\" \"&MID(A1,15,1)&\" \"&RIGHT(A1,1) where A1 contains "FastEthernet0/1/0" PERSONAL NOTE: I believe it is easier and faster to manually write/type "FastEthernet 0 1 0" than go through making out a formula. Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=507315 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reomving a set numer of characters from a text string | Excel Discussion (Misc queries) | |||
| summing characters in a string | Excel Worksheet Functions | |||
| select a string of characters | Excel Worksheet Functions | |||
| trim a string by specific number of characters | Excel Discussion (Misc queries) | |||
| Remove characters from a text string using a formula | Excel Discussion (Misc queries) | |||
Threaded Mode
