0
votes
2answers
228 views

Excel formula to split a cell and reverses the order

An example source cell would be something like: Some:Thing:random:here I want to transform it to this (reversing the order of each group): here:random:Thing:Some I would prefer a formula, ...
0
votes
1answer
264 views

Split last two words in a sentence into two different cells in MS Excel

Temasek Boulevard, Suntec Tower, (Singapore 0389) The above sentence is a address . The last two words is country name (singapore) and zipcode (0389). How to split country name and zip code in two ...
0
votes
1answer
222 views

MS-Excel - Split cell into rows

I have data in excel in the form of cell1 | cell2 1 | A, B, C 2 | A, D And I want to split the comma separated data into new rows. Like, cell1 | cell2 1 | A 1 | B 1 ...
1
vote
3answers
475 views

how can I split data into multiple columns seperating only after the first colon in excel

I have a huge excel list (20k+ rows) and want to split that one column list into multiple columns. Previously I used the Data|Text-to-Columns Wizard but it appears to have a limitation: I cannot ...
0
votes
2answers
3k views

text to column delimiter split at any number

How do I split a clustered alphanumeric column at the first instance of a number? Preferrably simpler than this.
2
votes
1answer
738 views

How to split cell in a row with Excel

I am trying to create a macro to split a cell containing two or more line of characters. I would like to keep the others cells of the row. For example _____________ | | A | |Row 1| B | | ...
0
votes
1answer
355 views

Vertical split with different row views

I have an excel spreadsheet with about 400 rows. I have a quick-review table with a bunch of countif cells that update based on the data in the rows. The table is in columns K-O while the actual data ...
0
votes
1answer
1k views

split a large excel into smaller files but include the header in all files

I have a macro that I use to break large excel spreadsheets into smaller files. It works perfectly, except, it only uses the header row in the first file created and this header row (row 1) needs to ...