Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an imported data with gaps of unequal size. To convert them I need to
add a special character in this case. What piece of code could replace a gap of 3 or more spaces with a pipe character "|". In other words, data like Name Region Rate Name 1 Region x Rate x Name 2 Region x Rate x Name 3 Region x Rate x Name 4 Region x Rate x Name 5 Region x Rate x could be converted to: Name Region Rate Name 1|Region x|Rate x Name 2|Region x|Rate x Name 3|Region x|Rate x Name 4|Region x|Rate x Name 5|Region x|Rate x because only the second row and onwards contain gaps of 3 more spaces and only a single "|" is inserted. Thanx in advance. -- Best Regards, Faraz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
Find/Replace Event or Find/Replace for Protected Sheet ... | Excel Programming | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
Using Find and Replace to replace " in a macro | Excel Programming | |||
Replace method - cannot find any data to replace | Excel Programming |