VBA to target a charachter in a specific location in given cell and write it back out

**Sparkplug90** · 02-10-2013, 04:53 PM

any ideas how to do it

**AlphaFrog** · 02-10-2013, 05:38 PM

Please Login or Register  to view this content.

**Sparkplug90** · 02-10-2013, 05:47 PM

Alpha..how does it work?..so I can understand it

**AlphaFrog** · 02-10-2013, 06:32 PM

Excel: MID Function

Cell B1 ("write it back out") gets the 3rd character ("target a character") in the text from A1 ("location in given cell")

Re: VBA to target a charachter in a specific location in given cell and write it back out