Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Left() or Right()
Hi, I have a list of postcodes (zip codes) that I need to 'extract' part of and allocate to a new cell. eg: AL1 2TQ AL1 5RD AL22 9IP I need to take the first characters before the space however it could be 3 or 4 characters before each space. I need a formula that will start from the left and take anything before a space or one that starts from the right and takes anything before the righthand 3 characters and the space. I've tried left and right but can't quite get it to work. Any ideas? Thanks in advance. -- giantwolf ------------------------------------------------------------------------ giantwolf's Profile: http://www.excelforum.com/member.php...o&userid=24718 View this thread: http://www.excelforum.com/showthread...hreadid=396875 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort Left to Right not working | Excel Discussion (Misc queries) | |||
Cell Borders and "Columns to Repeat at Left" | Excel Discussion (Misc queries) | |||
Scrollbar on Chart Jumps to Left when Chart is Clicked | Charts and Charting in Excel | |||
The left function does not work when displaying times, how is thi. | Excel Worksheet Functions | |||
header in right or left margin? | Excel Discussion (Misc queries) |