CODEWITHSUNDEEP
excel
user2789510
user2789510

Reputation: 1

Separate string to colum by delimiter without text to column wizard

How can you separate a string into separate columns delimited by quotes ("") without using the text to column feature... as in

A1={"WATERBOTTLES","HOWMANY":"8","HOWMUCHDOTHEYCOST":"1"}

B1=WATERBOTTLES, HOWMANY : 8, HOWMUCH DOTHEYCOST : 1

Upvotes: 0

Views: 437

Answers (1)

Viji
Viji

Reputation: 2629

You can replace the string "," into tab(\t) in Textpad. and copy paste the value in excel.

  • Replace the beginning double quote, as like replace ^" with empty string
  • Replace the last double quote, as like replace "\n with just \n

(Let me know, if you want screen shot, i can add it)

Each value will appear in different column.

Upvotes: 1

Related Questions