Free to try with no limitation in 30 days.

How to use cell text in formula in excel. This is the formula. Would it be possible to say A5A16 where A1B so it would result in A5B6 or A1C and it would change all the formulas to A5C6. So instead of directly linking to A1 you could say INDIRECT A1.

So the TEXT formula becomes TEXTB4hMMSS AMPM TEXTC4mdyyyy Dragging the Text formula to other cells we get the desired output in the format that we want. The FORMULATEXT can be used to extract a formula as text from a cell reference. Thank you in advance.

But want to change it across the whole sheet from Bs to Cs. It is supplied in the form of a format code enclosed in the quotation marks eg. In order to get the correct number format use the TEXT function and specify the number format.

But instead there is also another method. So if I have A5B6 A5B7 A5B8 etc. Kutools for Excel includes more than 300 handy Excel tools.

Format defining the format in which we need the text. Those using the Timesheet add-on note that the value in column C points to the same cell on every sheet. If you dont like use the above code you can apply Kutools for Excels Convert Text to Formula feature with its help you can also convert text strings to formulas at once.

So Id like to use the text or value from one cell as a part of a reference of another. However when I fill in the hardcoded start of the range it does work. Method 4 Using RIGHT Function.