ExcelBanter - Can I match the beginning of text in an Excel cell?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can I match the beginning of text in an Excel cell? (https://www.excelbanter.com/excel-discussion-misc-queries/72431-can-i-match-beginning-text-excel-cell.html)

David Greggs

Can I match the beginning of text in an Excel cell?

I am trying to match the beginning of a text string in a cell, so that I can
replace a character only at the beginning and not anywhere else. I have done
this with regular expressesions, such as ^ in the past. Is this possible in
Excel?

Marvin P. Winterbottom

Can I match the beginning of text in an Excel cell?

=left(a1,1)

"David Greggs" wrote:

I am trying to match the beginning of a text string in a cell, so that I can
replace a character only at the beginning and not anywhere else. I have done
this with regular expressesions, such as ^ in the past. Is this possible in
Excel?

All times are GMT +1. The time now is 08:59 PM.