text-to-columns

I've got a data set of 6,133 rows with cells of dates in the following format: Cell A1: Status A-2022-02-03; Status B-2022-03-11; Status C-2021-09-10 This is an example of the content in a given cell and I want to separate the statuses and their respective dates into separate columns (by using...

Hello Marvelous EXCELers, Here is what I have: In cell A2 I have a value (numeric), in cell B2 a set of codes (alphabetic) delimited with a comma. Here is what I need: I need to find out how many entries will be parsed into individual columns if I perform a Text-To-Columns operation on cell...

Hi All, First but definitely not my last contribution here! I am running into an issue with my macro where inconsistencies are appearing between various end-users. The issue falls in the pasting method; my macro starts off by pasting data from the clipboard into a new workbook and does some...

Hello very helpful people :) I registered on this website because i saw you guys are extremely knowledgeable in excel. I am just beginning VBA and i have encountered a problem i cannot solve. I basically need text-to-column functionality delimited by formatting (Bold, Italics, normal) I...

Hello All. Hopefully one of you other excel gurus can help me out. I currently use a keystroke macro tool AutoHotKey to do some data entry for me. Unfortuantely, I am one of those people with a job that includes two or more software programs that don't talk to each other but all need to have the...

Hi everyone, I'm trying to convert some data in a column (eg 05/23/2011 US Date format) into 23/05/2011 AU format. I'm using the text to column function in excel 2010. Whilst recording the macro, it converts everything perfectly, including the date requirement. However, when I run the...

Hi. I often copy my bank statement info from an online account and paste it into a spreadsheet, using Data>Text-to-Columns>Delimited>Other> "$" to separate and sort the info. One of my accounts, however, does not use dollar signs and so I have to paste the data into Notepad, manually add the...