Excel - Separating text with numbers text and brackets into separate cells

0 votes
Is it possible to separate the following text into separate cells: To separate four cells, what would be the first DBL Del (103), second DBL Del (200), third DBL Del (150), and so on? Text and numbers can both be different, but in general, the number denotes how often the text should be repeated and should be given a consecutive number from a bracket. Additionally, there may be additional text following a comma, such as 3 TPL Sup (120, 230, 102) and 2 SGL St. (227, 234)
Jan 5 in Others by Kithuzzz
• 28,700 points
71 views

1 answer to this question.

0 votes

You can try FILTERXML().

enter image description here

answered Jan 6 by narikkadan
• 53,160 points

Related Questions In Others

0 votes
1 answer

How to unmerge multiple cells and transpose each value into a new column in Pandas dataframe from excel file

Try this: df = pd.read_excel("Sample_File.xlsx", header=[0,1,2,3,4,5], index_col = ...READ MORE

answered Jan 8 in Others by narikkadan
• 53,160 points
108 views
0 votes
1 answer

Excel Conditional Formating to find numbers a cell with text

Try this: =OR(ISNUMBER(-MID(SUBSTITUTE(A1," ","~")&"~",seq,4))) where seq is a defined name that ...READ MORE

answered Jan 10 in Others by narikkadan
• 53,160 points
27 views
0 votes
0 answers

Replacing H1 text with a logo image: best method for SEO and accessibility?

i want to link my logo to ...READ MORE

Feb 14, 2022 in Others by Kichu
• 19,050 points
2,090 views
0 votes
1 answer

Replacing H1 text with a logo image: best method for SEO and accessibility?

<h1> <a href="http://stackoverflow.com"> ...READ MORE

answered Feb 21, 2022 in Others by narikkadan
• 53,160 points
669 views
0 votes
1 answer
0 votes
1 answer

How to automate split by delimiter in Excel (equivalent of =SPLIT in gSheets)

Multiple ways, one is to use FILTERXML(): Formula in B2: =TRANSPOSE(FILTERXML("<t><s>"&SUBSTITUTE(A2," ...READ MORE

answered Dec 29, 2022 in Others by narikkadan
• 53,160 points
92 views
0 votes
1 answer

Split and group values in excel

variant using scripting.dictionary: Sub test() Dim ...READ MORE

answered Jan 22 in Others by narikkadan
• 53,160 points
41 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
213 views
0 votes
1 answer

How to define excel SUMIFS criteria considering any text and numbers?

It essentially ignores column C's missing entry ...READ MORE

answered Oct 1, 2022 in Others by narikkadan
• 53,160 points
132 views
0 votes
1 answer

Excel how to fill all selected blank cells with text

Do the following to place the same ...READ MORE

answered Dec 16, 2022 in Others by narikkadan
• 53,160 points
49 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP