comma

Hello, I have a list of names that I will be using the CONCATENATE function on. However, they have to be in a particular format. Example: Column A1 has LAST NAMES Column B1 has FIRST NAMES Column A already has all of the Last Names IE "Doe" in A1. What it needs to look like is Doe, (Doe...

I have a VB program that imports old Fixed Width text files into Excel. Works great until there is a comma in one of the text fields. At that point it starts a new line right in the middle of the record. Is there a way to ignore or delete the comma? Thanks

I have a basic VB program that imports some old Fixed Width Text files into MS-Excel. It works ok until the "Description" field contains a comma. At that point the import starts a new line. Is there any way to not read the comma as a line break or even skip over the comma field? Thanks

Hi I have some funky numbers where I see only comma and not decimal <tbody> 296,86 5780,154,295,96 As you see there are all comma in the numbers above. 296,86 should be 296.86 </tbody><colgroup><col></colgroup>

I have a query which I am unable to solve. I have certain Values in Sheet1 in Col A as below 991121QR5, 991121XSX, 991234SSC, 991121SDF In Sheet2 I have following Values in Col A and B 991121QR5 100100 991121SDF 121212 991234SSC 123456 991121XSX 888888 I want to vlookup each value after...

Hi there, I have a userform with 10 text input fields. Each is named txt1 txt2 txt3.... txt10 The user can enter info into any of the boxes, but not necessarily all of them... When the user clicks the UPDATE button, it creates a string of the values and inserts a comma if <>"" : Dim...

hello all, I need a formula to extract value between last two comma in a string eg. aaa,bb_1,ccc,ddd,v output: ddd

Hi. I am trying to develop a formula to add a comma after every: "=1" or "<>1" example: if(AND(KO9=1MA9=1XJ9=1RG10=1RW10=1ZR10=1LG11<>1ZR11=1),11,"") note: the number of characters before the "=1", or "<>1" may change, ie KO9 to AFD13

Hi there, I have a numbers and text in a single cell (call it A1), namely: "L-HQ-0001,Entrance Foyer" I would like to split the string so that in cell B1 it would return the following result: "L-HQ-001" Therefore, removing the text along with the comma. Any assistance would be gratefully...

Here is the deal, i have 2 columns in a google sheet doc with a bunch of values and #error ! and #ref ! I use =$B:$B=max(IFERROR(B:B)) and =$C:$C=min(IFERROR(C:C)) to highlight the lowest value in C and the highest value in B, and ignore errors Problem 1= how to compute the spread and the...

I have a formula that combines the city, state and Zip fields in one field called CSZ. I want to show nothing in that field if there isn't an address provided But, if the address, city, state, or zip fields are null, I will get a ", " followed any field that may have something (e.g. ", CA")...

Hey everyone, hope all is well and happy early Thanksgiving.. I need some help.. I'm creating a spreadsheet where when someone is dispatched (it may be multiple people) you select the drop down and it enters there name, but it adds comas at the end of there name (except the last name). and enter...

Hi I have a need for a formula I think In a single cell I have loads of data that is separated by a comma and a space like: GU1, GU2, GU3 1, GU3 2, KT7 In this example there are only 5 sets of data but in an extreme situation there can be many many more. What I am trying to achieve is to...

VBA: hi, if there are multiple lines in any cell in column B, C or D then split each line by a comma in their respective cells.

Hi all, I'm trying to write some code in excel vba that will use the loop command to print numbers to cells, say from 1 to 100. I can get the numbers to print to cells however what I also need is each number to be wrapped in symbols like this. "X" , Including the comma. I've tried a few...

Dear Excel brains of the world, I have a data validation conundrum; spent an hour looking for a solution to no avail :( I have the following list of values: AR, ARNC, ARNF, ARSAP, B, C, E, ER, ES, N, T, V To prevent user error, I need to be able to add a Data Validation rule into the...

Hello! I have this problem for which I have been searching a solution for some time now. This may be due to lack of knowledge in Excel or poor skill of the English language. I need the first column to look like the second column - simply move the comma by one number to the left. Help would be...

Hello, I'm trying to automatically convert number formatting to match the style in some European countries by swapping the comma and period position from the USA style of, "123,456.78" to read like, "123.456,78". The problem I'm running into though is when I go to though... I go to Number >...

The macro below removes the comma from the string but changes some of the information into a decmil. For example, ,2536 8/22 becomes 2536 4/11. In the formula bar, it reads; 2536.36363636364. It should be; 2536 8/22 (just without the comma) I tried changing the Value2s to Value and then I...

Hi, I have an address the following formats in a cell: Customer Name, 1 Address, 2 Address, City, ST, 00000-0000, US Other Customer, 1 Address, City, ST, 12345, US I need a formula to just extract the “ST” state information. My problem is sometimes there is no “2 Address” and...