How to split text values by a delimiter

0 votes

I must examine a database. I want to use the delimiter @ to merge all of the necessary cells together. I now want to use the @ delimiter to divide the string value on a different sheet (see the screenshot). It must be carried out using a formula.

Screenshot of the worksheet

Oct 11, 2022 in Others by Kithuzzz
• 38,000 points
705 views

1 answer to this question.

0 votes

The Split function is what you are looking for:

=Split(A1, "@")

Example of Split used to split text by delimiter

answered Oct 11, 2022 by narikkadan
• 63,600 points

Related Questions In Others

+1 vote
0 answers

How to split a number with coma betweeen two colunms

Jul 3, 2019 in Others by anonymous
869 views
0 votes
1 answer

How to retrieve the value of a text field in Flutter App?

Hi@akhtar, In your TextField, you can call one ...READ MORE

answered Sep 3, 2020 in Others by MD
• 95,460 points
1,810 views
0 votes
0 answers

SEO - How to programmatically check if a website has been Banned by Google

i wanted to link a website to ...READ MORE

Feb 14, 2022 in Others by Kichu
• 19,040 points
391 views
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 63,600 points
1,110 views
0 votes
1 answer

Currency conversion:number to words excel

Try looking for javascript solutions to use ...READ MORE

answered Oct 28, 2022 in Others by narikkadan
• 63,600 points
616 views
+1 vote
1 answer

Excel or Google formula to count occurrences of an 8-digit number within a text string

To match an eight-digit number, you may ...READ MORE

answered Dec 24, 2022 in Others by narikkadan
• 63,600 points
1,009 views
0 votes
1 answer

Filter/Extract a text from excel sheet having similar values

ISNUMBER(SEARCH("Maria,",SUBSTITUTE(A1:A4,"]",",")))  shows TRUE if Maria is found and false if it would ...READ MORE

answered Jan 9, 2023 in Others by narikkadan
• 63,600 points
396 views
+1 vote
1 answer

Automatically move an entire row of reference cell when one cell is moved or manipulated

You are describing how manually entered data ...READ MORE

answered Jan 15, 2023 in Others by narikkadan
• 63,600 points
361 views
0 votes
1 answer

Excel, How to split cells by comma delimiter into new cells

The Excel manual method: choose Text to Column ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
• 63,600 points
913 views
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
616 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