| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I want to replace the first character in a column of text
We have a client that has several thousand rows of data in a single column
formatted as this example shows: A12345B. Where the alpha characters are any of the 26 available. They want to change the leading alpha character from whatever it is presently to an upper case X while leaving the rest of the line unaffected. Any and all help appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - Formatting text in cell (character by character) | Excel Discussion (Misc queries) | |||
| Find Character in Text and put value in next column | Excel Worksheet Functions | |||
| Excel: replace all 2 spaces to FF/LR in column of text | Excel Discussion (Misc queries) | |||
| HELP - How to replace CRLF with a character withing an excel column | Excel Discussion (Misc queries) | |||
| VBA code to define nbr of text character a a cell/column | Excel Programming | |||
Threaded Mode
