asked on Simple Macro to Single Column Values
Hello,
I have the attached spreadsheet with two columns of data - the first with a single value (col A) in and the second (col B) with either no value, a single value or multiple values with many values in separated by a comma (all multiple values are separated by a comma).
I could like to keep Col A as it is however I would like all the values in column B to be separated (if there are multiple in a cell) and copied to column A as single values or just copied to column A where there is a single value (i.e. no comma indicating multiple values) and just ignored if no value.
Could someone tell me if this is possible and how I may tackle this?
Many thanks in advance.
Regards
GISVPN
Book1---Copy.xlsx
I have the attached spreadsheet with two columns of data - the first with a single value (col A) in and the second (col B) with either no value, a single value or multiple values with many values in separated by a comma (all multiple values are separated by a comma).
I could like to keep Col A as it is however I would like all the values in column B to be separated (if there are multiple in a cell) and copied to column A as single values or just copied to column A where there is a single value (i.e. no comma indicating multiple values) and just ignored if no value.
Could someone tell me if this is possible and how I may tackle this?
Many thanks in advance.
Regards
GISVPN
Book1---Copy.xlsx
Microsoft Excel
Last Comment
gisvpn
ASKER
Hi there it could be either a semi colon or a colon! Sorry should have said this too!
ASKER
A comma should never be used!
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Great quality answer
Do you have a constant delimiter like you said in your question comma or it will be always like this??
Saurabh...