comma separated string

Hello and sorry for the crappy subject header. As stated i need to change "Smith, John" to "John Smith" but the name could be "Experticus, Vba" to "Vba Experticus" - dynamic length of each. I assuming it has something to do with" LEN", but that is one area that i cannot get to make sense to me...

I've just hit a wall here and my brain refuses to bring this information up. I have a cell with a series of room names in it, separated by commas: Master Bedroom, Master Bathroom, Laundry Room, Stairs, etc. Call this A1 In "D1" I'd like to place a formula that will take those room names and...

Hello, Is is possible to do a vlookup in a cell with comma separated values and return it in another comma separated value (in red) example : I want top obtain Col B result vlooking up in second table. Your help is the most welcome. Thanks Jacques. A B 1 GERMANY,SPAIN,FRANCE DE,SP,FR...

Hi People, Can you help me with below analysis using a VBA code. I have the sheet with below input in sheet1. It basically has two columns. Column A has ID and B has its category. an ID might have multiple lines and multiple categories each separated by comma. the possible categories are -...

hi, found a code on the web, which is working fine but i want add trim and clean the string, after add three line trim,clean and replace, it is getting hanged, any one please help me. Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range, Dn As Range, n As Long, s As Variant, Sp...

Hi Friends, i Have a difficult question to explain.:confused: As you see in below table, columns in green i have, column in red i am trying to get as result. Problem statement: Values of B column it should search in range (B2:B5), if a comma separated string is occurring in the range then it...

I am trying to lookup a value in a spreadsheet where multiple criteria is involved. Normally I'd approach this task with an index match function, however I am not 100% on how to get the formula started given that in this situation, some of the values being looked up exist in a cell with multiple...

Hello I need the first letter after a comma to be lower case, any help is more than welcome :)

I have a cell with these values in it can anyone shed any light on extracting the single values between the commas into their own individual cells. Thanks in advance guys. 2,5000,8,Y

I want to split the content in a column (Vendor 1, Vendor 2, Vendor 3) into different rows. <colgroup><col><col><col><col><col><col><col span="2"></colgroup><tbody> Name Type Name Vendor 1 Vendor 2 Vendor 3 Manager Available Apple 1 Kashmir Padma whole sale Fruit Junction; Juice corner...

Hi, I'm new to posting on forums like this so bare with me as I try to explain what I'm attempting to accomplish. My company has a lab and we run different tests for different samples. I'm trying to find the total time the sample will take to run based on the tests selected. We currently have...

Hi Guys, I download an excel file of survey answers on a monthly basis for a report. Each line item is an unique entry. For a particular questions (multiple select): example: Which fruits do you eat: A / B / C It puts all the answers into 1 cell separated by commas. Example "A, C" or "A" or...

Sorry if this seems like a silly question but todya is my first every macro experience! I am tryimg to create a macro that coverts a string of numbers into a sum: I.e. I want to turn £7,296.25, £2,245.00, £1,122.50, £561.25 into =7296.25+2,245.00+1122.50+561.25 So far I have added in thre...

Good day all, I am hoping someone can assist with my issue below. I have a column with various comma separated values, I would like to search for a particular answer within the string. Example: Column R contains the following: WD,WL, LI,AI,LD Column S: I would like to search for...