Forum Discussion
Solved
text to columns - keep delimter
using ">" as delimiter, for example, "chair > more text" works fine, but the result deletes the ">" from the first column. Need the first column to remain as "chair >" Very much appreciate your help!...
Select column, Ctrl+H, Find >, Replace on >@, Replace All, Text to Columns, Delimiter, Other delimiter @, Finish
Select column, Ctrl+H, Find >, Replace on >@, Replace All, Text to Columns, Delimiter, Other delimiter @, Finish
- Sergei Baklan - took me a while to get back to this. Your suggestion works PERFECTLY! Thanks very much!
