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, 2023 in Others by Kithuzzz
• 38,000 points
896 views

1 answer to this question.

0 votes

You can try FILTERXML().

enter image description here

answered Jan 6, 2023 by narikkadan
• 63,600 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, 2023 in Others by narikkadan
• 63,600 points
2,516 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, 2023 in Others by narikkadan
• 63,600 points
476 views
0 votes
1 answer

Looping through a folder with Excel files and scraping date from selected cells usin VBA

You record the outcome of your comparison ...READ MORE

answered Feb 16, 2023 in Others by narikkadan
• 63,600 points
944 views
0 votes
1 answer

Excel Date separate with =DAY(), =MONTH() and =YEAR()

If it must be done inside of ...READ MORE

answered Mar 20, 2023 in Others by narikkadan
• 63,600 points
576 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
• 63,600 points
595 views
0 votes
1 answer

Split and group values in excel

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

answered Jan 22, 2023 in Others by narikkadan
• 63,600 points
593 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,690 points
3,935 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
• 63,600 points
935 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
• 63,600 points
421 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