Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing multiple instances of character
Hi,
Trying to sort out a spreadsheet that someone's given me... a type-up of a WW2 pilot's logbook. For one set of information (pilot flying times) has been typed in a single column using the Spacebar to line up the 4 columns of data (rather than using 4 separate columns). So, what I want to do is to convert this. So, what I thought was to replace the spaces with a single comma between each set of data which I could then do a data parse to separate. Unfortunately, there are various number of spaces between each of the sets of data, so any suggestions of a quick way of doing this? The way that I thought was to use the SUBSTITUTE function & somehow use a * wildcard to allow it to deal with different numbers of spaces, but either I'm doing it wrong, or it can't be done that way. Any suggestions? Cheers from a snowy & cold Manchester! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Instances of a Specific Character | Excel Discussion (Misc queries) | |||
Create list of unique instances from list of multiple Instances | Excel Worksheet Functions | |||
Using Replace command for replacing a character by an ALT+ENTER | Excel Worksheet Functions | |||
Replacing spaces in text, with another character | Excel Worksheet Functions | |||
INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell | Excel Worksheet Functions |