2016年9月29日星期四

Divide information into two columns [Solved]

Divide information into two columns

If column A contains the following:
 
A
black, red 65
green, blue, orange 710
brown 7
 
How can I place just the numbers in the second column B:
 
A                                                         
B
black, red                                          65
green, blue, orange                          710
brown                                                7
 
Any suggestions?
 
Thank you,
 
Bill

Keys to the Problem Divide information into two columns

Download Error Fixer (Free)

...
Could you offer some help ...
 

Can you post a sample worksheet to a public file area like 4Shared, SendSpace or Uploading and
post the location back here? I can run some code on the sample to find out what strange characters are causing your problems with the import.

BTW, other non-printable characters hung-over from a web page copy and paste operation can be stripped with the CLEAN() function.
You might try the following in C1,

=--TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(CLEAN(A1),CHAR(160)," ")," ",REPT( " ",99)),99))
...
and this is B1,
=TRIM(SUBSTITUTE(SUBSTITUTE(CLEAN(A1),CHAR(160), " " ),C1,""))
...
and fill down as necessary.

I'll try and keep an eye out for your reply.

Tweak IE Options
  • Open Internet Explorer.
  • Go to "Tools > Internet Options > Advanced Tab".
  • Uncheck "Enable third-party browser extensions".
  • Click "Apply".
  • Reboot your computer.

Another Safe way to Fix the Problem: Divide information into two columns:

How to Fix Divide information into two columns with SmartPCFixer?

1. Download SmartPCFixer. Install it on your computer.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been removed.


Related: Way to Update & Download SONY SVE14A2X1EH Wireless State Device driver,How to Update & Download SONY SVS1511X9RB Graphics Driver for D2 (Intel) v.9.17 - 9.17.10.2828,Method to Download SONY VGN-CR290N Realtek High Definition Audio Driver v.5.10.0.5433,Download SONY VGN-FS710/W Utilities DLL Update v.6.4.0.06290 driver,Method to Update & Download SONY VGN-NR460E/P Intel Graphics Media Accelerator Driver v.6.14.10.4847,How to Fix Error 0x0000c1f5 Solución?,Error 0x80071a91 Win7 Fix Patch,Error 0x800ccc60 Windows Live Mail [Solved],Error Message 0x800ccc79 Outlook 2000 Fix,What is Error 0xc1ab0001?,[Answered] x64 saplugin dll,How to Fix Problem - Kb943729 Download?,Troubleshooting: Bccode D1 Error,Java Runtime Tech Support,Troubleshooting: ERROR NO SUCH GROUP Error,Solution to ashoutxt.dll Missing Error,Solution to cxcore096.dll Missing Error,Where can I Find dsauth.dll File,How to Fix msde.dll Not Found Error,Best Method to Fix psizewizres.dll Error
Read More: Double Click Word Selection Character Set(Word 2010) Tech Support,Troubleshoot:downloading attachments,Tech Support: Download does not start from the internet.,Does Windows 7 include DirectX 11 [Solved],Display a term next to a cell that falls within a given range ? [Anwsered],Data validation question. Maintaining and updating named ranges.,Desktop Gadget Gallery on Windows 7,delete empty rows,Deleting a page and also how can I copy an exact page lay out on a new page,Date Formula for 1st Sunday of each Month (3rd to 9th)

没有评论:

发表评论

注意:只有此博客的成员才能发布评论。