| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help with unusual request?
Assuming your data is seperated by spaces, you can try this in a blank column: =IF(ISERROR(LEFT(A1,FIND(" ",A1)-1)),IF(A1="","",A1),LEFT(A1,FIND(" ",A1)-1)) copied down...once you have done that just copy and paste over your existing data (Paste as Values). NOTE! if your data is seperated by something other than "spaces" say "comas" then change FIND(" " to FIND("," in the formula. HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=496061 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP - problem in stock request | Excel Worksheet Functions | |||
| Where do I find the Payment Request Wizard in Outlook? | Excel Discussion (Misc queries) | |||
| Unusual filter request | Excel Discussion (Misc queries) | |||
| How to Create an Excel Macro to send a meeting request. | Excel Discussion (Misc queries) | |||
| trendline - request power --> get linear | Excel Worksheet Functions | |||
Threaded Mode
