commas

in one cell I have data such as: d10d100i01d09d07i04 and i am hoping to to add a comma before each letter so that it appears like this: d10,d100,i01,d09,d07,i04 i dont mind if it has to add a comma before the first one either: ,d10,d100,i01,d09,d07,i04 i have a lot of data like this and need...

Good afternoon! I have a spreadsheet that has a fairly large amount of validation built in. In some circumstances, users will cut and paste data into multiple cells in a column (which could be anywhere from 1-10,000 cells in the column). The data coming from the source document sometimes...

I have an excel list of about 300+ names. Each name is in the same cell written as "LAST NAME FIRST NAME MIDDLE INITIAL" with no commas. (Ex. Doe Jane A). I need a way to insert a comma ONLY after the first word in the cell so it will read "Doe, Jane A". Is there any way to do this without...

Excel is inserting "unwanted quote marks" around text fields containing commas or other special characters when exporting a file in "tab-delimited" format. Is there a standard option or something to disable this behaviour without having to write a macro to prevent it? Thanks. J. David...

I'm trying to get an understanding of this formula used in a routine that creates one validation list based on another. Can anyone tell me what the +1,2,,, portion of this formula does? =OFFSET(INDIRECT(ADDRESS(MATCH(Val1Cell, Objects,0)+1,2,,,"Lists")),0,0,COUNTIF(Objects,Val1Cell),1)

This is frustrating me! I want to create a data validation list where some of the entries contain a comma. So I do like this: which gives me what I want, namely entries containing commas: I save the file and everything is fine... until I reopen it again. Then I see this: and when I go...