Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've been trying to do this with a macro but I think VB is needed and I'm
"not" a VB developer so I really hope one of you can help me out. This is the last major thing I need to make this thing work. I have records with columns Group, FName, LName, and Combined. If there are more than 30 characters in the Combined field, I need to move the full names to the next line, remove the "^" at the end or beginning of the line (depending on what was moved) and copy the other fields in the original line. Uploading the list otherwise makes the program bomb for some reason. I hope someone out there can help me. group name combined marketing mjagger mjagger^rthomas^xbono marketing rthomas mjagger^rthomas^xbono marketing xbono mjagger^rthomas^xbono accounting rcharles rcharles^jbrown accounting jbrown rcharles^jbrown hr jmayer jmayer it jjohnson jjohnson^bdylan^joplin^jfoggerty^braitt it bdylan jjohnson^bdylan^joplin^jfoggerty^braitt it jjoplin jjohnson^bdylan^joplin^jfoggerty^braitt it jfoggerty jjohnson^bdylan^joplin^jfoggerty^braitt it braitt jjohnson^bdylan^joplin^jfoggerty^braitt The example above would become: group name combined marketing mjagger mjagger^rthomas^xbono marketing rthomas mjagger^rthomas^xbono marketing xbono mjagger^rthomas^xbono accounting rcharles rcharles^jbrown accounting jbrown rcharles^jbrown hr jmayer jmayer it jjohnson jjohnson^bdylan^joplin it jjohnson jfoggerty^braitt it bdylan jjohnson^bdylan^joplin it bdylan jfoggerty^braitt it jjoplin jjohnson^bdylan^joplin it jjoplin jfoggerty^braitt it jfoggerty jjohnson^bdylan^joplin it jfoggerty jfoggerty^braitt it braitt jjohnson^bdylan^joplin it braitt jfoggerty^braitt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
How to change line chart color based on condition like + and -. | Charts and Charting in Excel | |||
how to delete an excel line based on a condition | Excel Worksheet Functions | |||
average Line created in an existing line graph- based on one cell | Charts and Charting in Excel | |||
A 2 line text showing up in the Cell in Excel prints in 1 line | Excel Discussion (Misc queries) |