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!

srp44 Select column, Ctrl+H, Find >, Replace on >@, Replace All, Text to Columns, Delimiter, Other delimiter @, Finish

Forum Discussion

Copper Contributor

Apr 21, 2020

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!

excel

Formulas and Functions

SergeiBaklan
Apr 22, 2020
srp44

Select column, Ctrl+H, Find >, Replace on >@, Replace All, Text to Columns, Delimiter, Other delimiter @, Finish

3 Replies

SergeiBaklan
Diamond Contributor
Apr 22, 2020
srp44

Select column, Ctrl+H, Find >, Replace on >@, Replace All, Text to Columns, Delimiter, Other delimiter @, Finish
- srp44
  Copper Contributor
  Apr 28, 2020
  Sergei Baklan - took me a while to get back to this. Your suggestion works PERFECTLY! Thanks very much!
DhaniCole
Brass Contributor
Apr 21, 2020
srp44
You could import the data into power query. Add a setup to replace every occurrence of > with >>. Then when you do your split (in power query still), you can select to only split the right-most occurrence of >, then load to a second table in excel-see attached.
split.xlsx18 KB